Forum Discussion

mahsy's avatar
mahsy
Helper I
4 years ago
Solved

Replace NULL with 0 in matrix

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 !

  • 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

2 Replies

  • 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's avatar
      mahsy
      Helper I

      It works, thank you very much !!