Forum Discussion

Megner's avatar
Megner
New Member
3 years ago

COUNTIF On a Power BI Measure

Hi

 

I have a graph which looks at each month and gives a % Pass Rate. The red, yellow and green lines are indicators for threshold (red), target (yellow) and stretch (green) KPI's. 

 

 

These are my fields below

 

 

Column and Line y-axis' are Power BI measures, e.g.

 

 

I would like to create a new table/matrix visual which says how many times that the percentage is below the Threshold (97%), Target (98%), Stretch (99%).

i.e. the graph in the first screenshot I would expect to view something like..

 

 

I tried to create a new column with a condition, but it won't allow it because the "Pass Rate" is a measure.

 

Any ideas?

 

Many thanks in advanced.