Replace NULL with 0 in matrix

[mahsy]

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 · Accepted solution]

@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]

It works, thank you very much !!