Null values in matrix visual

[rajulshah]

Hello everyone,

I have data something like this in my table :

And I have plotted the matrix visual as below but I only want to show names if there are values in all the three columns.

So here , I only want data to be shown is of 'A'.

Can anyone help me out how to achieve this?

Thanks in advance.

[v-chuncz-msft · Accepted solution]

@rajulshah,

You may use the following measure instead.

Measure =
IF (
    CALCULATE ( DISTINCTCOUNT ( Table1[Type] ), ALLSELECTED ( Table1[Type] ) )
        = COUNTROWS ( ALLSELECTED ( Table1[Type] ) ),
    SUM ( Table1[Value] )
)

[rajulshah]

Thank you so much @v-chuncz-msft! It really helped. 🙂