I'm working on a KPI monitoring dashboard and I would like to calculate the number of metrics in a each category that have more than a 30% increase QoQ. I tried using a indicator in the first table below to show if there was a metric change greater than 30% QoQ, but that doesnt translate into the category (2nd table) when I create another view. These views would be filtered with a quarterly filter.
The % increase field below is a measure that looks like this:
Average of Metric Value QoQ% =
ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),