Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Measures

PabloDeheza's avatar
PabloDeheza
Icon for Solution Sage rankSolution Sage
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    Hey i tried that and it is returning this:

     

    • PabloDeheza's avatar
      PabloDeheza
      Icon for Solution Sage rankSolution Sage
      4 years ago

      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's avatar
        Anonymous
        Not applicable
        4 years ago

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