Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
  • kentyler's avatar
    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.