Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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())))
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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())))