DAX treats BLANK as 0, how to prevent it?

DRams_316 · ‎12-09-2020

I'm calculating a column based on the values from other columns that has NULL values, I do not want DAX to return 0 if the value is NULL.

v-yuaj-msft · ‎12-21-2020

Can you share some screessnhots around the issue please? This is not helping much.

Add error screesnhot as well which you are facing.

Best Regards,

Yuna

mahoneypat · ‎12-09-2020

Please share you column/measure expression. That does not sound like the default behavior. It is probably your expression.

Regards,

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

Helpful resources