Forum Discussion
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.
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
2 Replies
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