Desktop

[DAX_Learner]

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.

[MFelix · Accepted solution]

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:

See PBIX file attach.

Regards,

Mfelix

Novalue.pbix

[DAX_Learner]

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.

[MFelix · Accepted solution]

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:

See PBIX file attach.

Regards,

Mfelix

Novalue.pbix