Measures

[PabloDeheza]

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(
    ISBLANK( COUNT( PROJECT_DATABRICKS[CNT_AT_RISK1] ) )
        && ISBLANK( COUNT( PROJECT_DATABRICKS[CNT_OFF_TRACK] ) )
        && ISBLANK( COUNT( PROJECT_DATABRICKS[CNT_ON_TRACK] ) ),
    "No data available for on-track vs off-track vs at-risk projects",
    BLANK()
)

Let me know if that helps!

[Anonymous]

Hey i tried that and it is returning this:

[PabloDeheza]

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

[Anonymous]

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

[PabloDeheza]

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

[PabloDeheza]

Maybe I am misunderstanding the requierement here. The measure we created will only show the message if and only if the three columns that we are using return blank at the same time. Maybe you dont see the message because one of those counts is returning you an actual value. If this is not the behaviour you need, then perhaps we need to review the conditions we set in the IF statement.

[Anonymous]

Thanks for responding. I'll cross check again.