Replacing Blanks with 0 in Power BI Visuals: DAX Measures Not Working

[Anonymous]

Hello everyone,

I’ve been working with Power BI for several months now, but I’ve never faced an issue as frustrating as this one.

In my visuals, there are cells displaying blanks, and none of my DAX measures to replace those blanks with 0 seem to work. For example, I’ve tried using COALESCE(COUNTROWS(Sheet1), 0) + 0 and IF(ISBLANK(COUNTROWS(Sheet1)), 0, COUNTROWS(Sheet1)), but the blanks persist.

I’ve attached a sample file for reference and would really appreciate it if someone could guide me on resolving this issue. Thank you!

https://drive.google.com/file/d/1PHmj3qBqhn_cKe0Nu4lPeRe1MkEm-N6R/view?usp=sharing

[mark_endicott · Accepted solution]

@Anonymous - This is because everything is from the same table, and you're trying to add a 0 into a row that does not exist, so the visual cannot show the 0. 

To make this work you need to create a calculated table that stores your dates, a 0 can then be put against this because the date exists in a different table. 

In my attached file you will see how I have acheived this. You will also notice that my visual on the left now uses the date from the new table and works, where as the table on the right uses the old date column and the measure does not work as desired.

If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!

[Cabbage_Baby]

omg this works! Thank you!

[Greg_Deckler]

@Anonymous It's almost certainly an auto-exist issue. Go here and do this:

If you don't see this option, you may need to turn it on in Preview features (because everything is a preview feature now).

[Cabbage_Baby]

Thank you, Greg! I really appreciate your help, but sadly, this didn’t quite solve the issue.