Forum Discussion
Health 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 creating some custom measures in each section which gives a value of 0 or 1 based on the threshold being breached. Based on that I am highlighting the cells using conditional formatting to
I am looking to create a measure that shows the overall status of a section. Now I have used conditional formatting to highlight a cell in red if it breaches threshold but I wanted a measure which should show the overall status as well.
For e.g. In below image if you see one cell is red cause because the threshold is breached, so I want a overall status card to show as “Unhealthy” if any cell is red.
Hi Anonymous ,
If any cell is red then show as “Unhealthy” means that if one line in the measure has a value of 0 or 1 then show as “Unhealthy”.
So I created a measure like the following:
Measure 2 = var _table=ADDCOLUMNS('Table',"value",[Measure]) return IF(COUNTROWS(_table)=SUMX(_table,[Measure]),"Healthy","Unhealthy")Here is a demo, please try it:
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous ,
If any cell is red then show as “Unhealthy” means that if one line in the measure has a value of 0 or 1 then show as “Unhealthy”.
So I created a measure like the following:
Measure 2 = var _table=ADDCOLUMNS('Table',"value",[Measure]) return IF(COUNTROWS(_table)=SUMX(_table,[Measure]),"Healthy","Unhealthy")Here is a demo, please try it:
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.