Forum Discussion
Solved
Replacing (Blanks) with 0
Hi, I have a number of Cards in my dashboard that return numbers. When I selected a filter where there no numbers, instead of displaying 0, it displays (Blank), and looks very ugly. Is there an e...
so you are using the raw source data, is it correct?
So its easy to you just make new column with this code
Column = IF(ISBLANK(**original column**),0,**original column**)
**original column** - your name for the column you are using.
Then change the value to the new column and it should work :)
Simple, as jthomson states. Create your Measure then add +0
Below is a measure to count the number of 2008 OS as it came up (Blank) made my report ugley.
Count of OS for Windows Server 2008 =
CALCULATE(
COUNTA('Company'[OS]),
'Company'[OS]
= "Windows Server 2008"
) +0
Great quick Solution 🙂