topic Re: Replace NULL with 0 in matrix in DAX Commands and Tips

Replace NULL with 0 in matrix

mahsy — Mon, 07 Feb 2022 12:03:07 GMT

Hi,

I want to replace empty cells with 0 in matrice. Is it possible ?

Measure = SUM('Table'[value])+0 does not work. (Neither IsBlank(value))

Thank you for your help !

amitchandak — Mon, 07 Feb 2022 12:43:14 GMT

mahsy , if they are coming from the same table and the combination is not there even +0 might fail

Create a new dimension for axe3, join with your table and use it from dimension and they try a +0 measure

mahsy — Mon, 07 Feb 2022 12:56:58 GMT

It works, thank you very much !!