Measures

Question

pablodeheza · Answer

Hi there!
For what I can see you want to check if every count is blank, then you want to display the message. So I think the correct measure would be this one:
Measure =IF(&nbsp;&nbsp;&nbsp;&nbsp;ISBLANK(&nbsp;COUNT(&nbsp;PROJECT_DATABRICKS[CNT_AT_RISK1]&nbsp;)&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;ISBLANK(&nbsp;COUNT(&nbsp;PROJECT_DATABRICKS[CNT_OFF_TRACK]&nbsp;)&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;ISBLANK(&nbsp;COUNT(&nbsp;PROJECT_DATABRICKS[CNT_ON_TRACK]&nbsp;)&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;"No&nbsp;data&nbsp;available&nbsp;for&nbsp;on-track&nbsp;vs&nbsp;off-track&nbsp;vs&nbsp;at-risk&nbsp;projects",&nbsp;&nbsp;&nbsp;&nbsp;BLANK())
&nbsp;
Let me know if that helps!

anonymous · Answer

Hey i tried that and it is returning this:&nbsp;

pablodeheza · Answer

Oh right, I added a BLANK at the end, lets replace that with "" as you did before:IF(&nbsp;&nbsp;&nbsp;&nbsp;ISBLANK(&nbsp;COUNT(&nbsp;PROJECT_DATABRICKS[CNT_AT_RISK1]&nbsp;)&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;ISBLANK(&nbsp;COUNT(&nbsp;PROJECT_DATABRICKS[CNT_OFF_TRACK]&nbsp;)&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;ISBLANK(&nbsp;COUNT(&nbsp;PROJECT_DATABRICKS[CNT_ON_TRACK]&nbsp;)&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;"No&nbsp;data&nbsp;available&nbsp;for&nbsp;on-track&nbsp;vs&nbsp;off-track&nbsp;vs&nbsp;at-risk&nbsp;projects",&nbsp; &nbsp; "")

anonymous · Answer

Hi I tried this as well, now its showing blank like this:&nbsp;

pablodeheza · Answer

But that is correct because you have values on your counts, so there should be no message to show.

Forum Discussion

Measures

7 Replies

Related content

Measure

DAX Measure

Path Measure

% of total measure

Count Measure