Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Replacing empty cells in Matrix visual

Hi folks,   I want to replace empty cells in Matrix Visual. Please suggest DAX query or any function .             Any help would be appreciated. Thanks in advance.    
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Hi Anonymous,

     

    Create a table with the Div unique values and make a relationship with the other table then create the following measure

     

    No Value Measure =
IF ( SUM ( Table1[Value] ) = BLANK (); "No Value"; SUM ( Table1[Value] ) )

    Result below:

     

    See PBIX file attach.

     

    Regards,

    Mfelix

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
7 years ago

Hi Anonymous,

 

Create a table with the Div unique values and make a relationship with the other table then create the following measure

 

No Value Measure =
IF ( SUM ( Table1[Value] ) = BLANK (); "No Value"; SUM ( Table1[Value] ) )

Result below:

 

See PBIX file attach.

 

Regards,

Mfelix