topic Re: Replacing Blanks with 0 in Power BI Visuals: DAX Measures Not Working in DAX Commands and Tips

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

Anonymous — Thu, 13 Feb 2025 14:42:11 GMT

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

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

Greg_Deckler — Thu, 13 Feb 2025 15:22:47 GMT

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).

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

mark_endicott — Thu, 13 Feb 2025 16:12:23 GMT

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!

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

Cabbage_Baby — Fri, 14 Feb 2025 06:48:22 GMT

omg this works! Thank you!

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

Cabbage_Baby — Fri, 14 Feb 2025 06:50:31 GMT

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