Forum Discussion
Solved
Replacing default text for blank
Hi, In one of my dashboards, when i choose a combination of values in slicers some of my measures display "blank". While this is correct, because there aren't any values for some combinations, wo...
Hi,
You should be able to achieve this by wrapping the measure in an if statment. e.g.
if(isblank(Your measure),"Whatever you want the value to be",Your Measure)
Here's a live example:
Measure 5 = if(isblank(CALCULATE(sum('Table (8)'[column2]),value('Table (8)'[Column1])=01/04/2023)),"There are none",CALCULATE(sum('Table (8)'[column2]),value('Table (8)'[Column1])=01/04/2023))If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi,
You should be able to achieve this by wrapping the measure in an if statment. e.g.
if(isblank(Your measure),"Whatever you want the value to be",Your Measure)
Here's a live example:
Measure 5 = if(isblank(CALCULATE(sum('Table (8)'[column2]),value('Table (8)'[Column1])=01/04/2023)),"There are none",CALCULATE(sum('Table (8)'[column2]),value('Table (8)'[Column1])=01/04/2023))
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍