Reply
Regular Visitor
Posts: 30
Registered: ‎10-25-2018
Accepted Solution

Replacing empty cells in Matrix visual

Hi folks,

 

I want to replace empty cells in Matrix Visual.

Please suggest DAX query or any function .

 

TestData.PNG

 

 

 

 

 

Any help would be appreciated.

Thanks in advance.

 

 


Accepted Solutions
Highlighted
Super User
Posts: 2,258
Registered: ‎09-19-2016

Re: Replacing empty cells in Matrix visual

Hi @DAX_Learner,

 

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:

novalue.png

 

See PBIX file attach.

 

Regards,

Mfelix

 



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

Attachment

All Replies
Regular Visitor
Posts: 30
Registered: ‎10-25-2018

#Replacing empty cells in Matrix visual #

Hi folks,

 

I want to replace empty cells in Matrix Visual.

Please suggest DAX query or any function .

 

TestData.PNG

 

 

 

 

 

Any help would be appreciated.

Thanks in advance.

 

 

Highlighted
Super User
Posts: 2,258
Registered: ‎09-19-2016

Re: Replacing empty cells in Matrix visual

Hi @DAX_Learner,

 

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:

novalue.png

 

See PBIX file attach.

 

Regards,

Mfelix

 



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Attachment