Count Metric categories above a threshold

Question

Hi Experts,&nbsp;&nbsp;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.&nbsp;The % increase field below is a measure that looks like this:&nbsp;Average of Metric Value QoQ% = IF(&nbsp;&nbsp;&nbsp;&nbsp;ISFILTERED('Sheet1'[Date]),&nbsp;&nbsp;&nbsp;&nbsp;ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),&nbsp;&nbsp;&nbsp;&nbsp;VAR __PREV_QUARTER =&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AVERAGE('Sheet1'[Metric Value]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DATEADD('Sheet1'[Date].[Date], -1, QUARTER)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;RETURN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DIVIDE(AVERAGE('Sheet1'[Metric Value]) - __PREV_QUARTER, __PREV_QUARTER))&nbsp;The data looks like this:CategoryMetric% increasePeopleNew Hires10TechnologyNew Systems Implemented32CultureWhistleblower Complaints45CultureNumber of Trainings completed16PeopleTerminations35&nbsp;The table im trying to create would then look like this:&nbsp;Category# of Metrics above 30%People1Technology1Culture1&nbsp;Any guidance would be much appreciated!&nbsp;

anonymous · Accepted Answer

I figured it out...&nbsp;&nbsp;Measure = countx(values(Sheet1[Metric Name]),if([Average of Metric Value QoQ%]&gt;=.3,1,if([Average of Metric Value QoQ%]&lt;=-.3,1,blank())))

Forum Discussion

Count Metric categories above a threshold

1 Reply

Related content

Conditional Formatting with Different Thresholds per Category

5000 threshold sharepoint connection - PBI

Fabric Capacity Metrics

Usage Metric report Refresh Issue

Report usage metrics

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