Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 cr...
Need Help
v-joesh-msft's avatar
v-joesh-msft
Solution Sage
6 years ago

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:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EYJaUqUPS-JJlyQe_q64-6EBKDdG6Kr_AzkP7G4dHJiHOA?e=2KCADe

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.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you so much. This measure is what I was looking for.