cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Justl2003
New Member

Count Metric categories above a threshold

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:

CategoryMetric% increase
PeopleNew Hires10
TechnologyNew Systems Implemented32
CultureWhistleblower Complaints45
CultureNumber of Trainings completed16
PeopleTerminations35

 

The table im trying to create would then look like this:

 

Category# of Metrics above 30%
People1
Technology1
Culture1

 

Any guidance would be much appreciated! 

1 ACCEPTED SOLUTION
Justl2003
New Member

I figured it out... 

 

Measure = countx(values(Sheet1[Metric Name]),if([Average of Metric Value QoQ%]>=.3,1,if([Average of Metric Value QoQ%]<=-.3,1,blank())))

View solution in original post

1 REPLY 1
Justl2003
New Member

I figured it out... 

 

Measure = countx(values(Sheet1[Metric Name]),if([Average of Metric Value QoQ%]>=.3,1,if([Average of Metric Value QoQ%]<=-.3,1,blank())))

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors