Forum Discussion

rajulshah's avatar
rajulshah
Resident Rockstar
8 years ago
Solved

Null values in matrix visual

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.

Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    rajulshah,

     

    You may use the following measure instead.

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

2 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    8 years ago

    rajulshah,

     

    You may use the following measure instead.

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