Hi Experts,
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% =
IF(
ISFILTERED('Sheet1'[Date]),
ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
VAR __PREV_QUARTER =
CALCULATE(
AVERAGE('Sheet1'[Metric Value]),
DATEADD('Sheet1'[Date].[Date], -1, QUARTER)
)
RETURN
DIVIDE(AVERAGE('Sheet1'[Metric Value]) - __PREV_QUARTER, __PREV_QUARTER)
)
The data looks like this:
| Category | Metric | % increase |
| People | New Hires | 10 |
| Technology | New Systems Implemented | 32 |
| Culture | Whistleblower Complaints | 45 |
| Culture | Number of Trainings completed | 16 |
| People | Terminations | 35 |
The table im trying to create would then look like this:
| Category | # of Metrics above 30% |
| People | 1 |
| Technology | 1 |
| Culture | 1 |
Any guidance would be much appreciated!
