Forum Discussion
Anonymous
6 years agoNot applicable
Status Card
Hi All, I am creating a Health Check report on Power BI. I have various sections and each section has different guidelines and thresholds to be classified as "Healthy" or "Unhealthy". Now I am cr...
- 6 years ago
I built a dummy table and loaded it. Then I added a calculated column to tell if each line had breached the threshold
Then I wrote a measure to count all the 1's
I used 2 different tactics. One was to use a calculated column, because i needed access to a row context to easily calculated whether a row had exceeded or not.
The other was to use a measure, because i needed to use Calculate and All to reset the filter context so my count would count all the rows in the table, regardless of whether or not a user had clicked on one of the rows in the interface.
kentyler
6 years agoSolution Sage
I built a dummy table and loaded it. Then I added a calculated column to tell if each line had breached the threshold