topic DAX to Remove blank rows from a calculated column in DAX Commands and Tips

DAX to Remove blank rows from a calculated column

Anonymous — Thu, 26 May 2022 20:24:30 GMT

Hello Guys,

I have a calculated column which return me blank values, because a I have a lot of blank rows in a column.

Considering this DAX:

What function should I use to eliminate or add 0 to these blank rows?

Thanks in advance!

Re: DAX to Remove blank rows from a calculated column

Nathaniel_C — Thu, 26 May 2022 21:41:44 GMT

Hi Anonymous ,
You might try wrapping this in an If - IF(your whole measure = null),0 , your whole measure)

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel