Forum Discussion
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.
2 Replies
- AnkitKukrejaSuper User
Hi Megner
You can try looking at some previously solved posts: https://community.fabric.microsoft.com/t5/Desktop/Calculate-Remaining-Items/td-p/1603547
Also, please make sure dax is posted under DAX/Desktop channel and not Service.
- MegnerNew Member
Sorry, I am a new user. I tried to follow the link, but it is too confusing for me...