Solved: Hide a total of one of my columns in a Matrix Tabl...

Anonymous · ‎03-20-2019

Comminity!!!! IT is Possible to delete the total of only one of my columns?...I need to get rid of it...take a look at the pic:

v-chuncz-msft · ‎03-25-2019

@Anonymous ,

Use the following measure instead.

Measure =
IF ( ISINSCOPE ( Table1[GRUPO] ), SUM ( Table1[Value] ) )

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

AlB · ‎03-20-2019

Hi @Anonymous

You could return a blank when ISFILTERED('Table'[The field you have on rows of the matrix visual]) is false. Something along these lines:

C BU PROY = IF( ISFILTERED('Table'[GRUPO]),
                [Your Current Measure]
              )

Anonymous · ‎03-21-2019

Hi!!1 @AlB it is not a measure.... it is just a column I have in a excel table.

In this case how would be the DAX?

v-chuncz-msft · ‎03-25-2019

@Anonymous ,

Use the following measure instead.

Measure =
IF ( ISINSCOPE ( Table1[GRUPO] ), SUM ( Table1[Value] ) )

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.