Displaying a measure only as Grand Total

[Zarlot531]

Is there a way to show a given measure only as a Grand Total? 

[v-cherch-msft · Accepted solution]

Hi @Zarlot531 

I would suggest you may use ISFILTERED function.

Reference:https://powerpivotpro.com/2013/03/isfiltered-a-better-way-to-detect-totals/

Measure 2 = IF(ISFILTERED(Table[column]),Blank(),[Measure])

Regards,

[jdbuchanan71]

Hello @Zarlot531 ,

You should be able to use 

IF ( ISSUBTOTAL ( table[column]), [measure], BLANK() )

You will juse need reference one of the columns visable in your matrix.