Turn Off a Total from a Table Visual

[Sean-OReilly]

Hi

How turn off the Total on Column "Vendor Rate Description"?

This row is generated using a DAX Switch Measure and it is a Text based Column?

[Greg_Deckler]

@Sean-OReilly - You can turn off Totals in the Format pane. However, if you want it just for that measure,

Measure =
  VAR __Calc = <some calc>
RETURN
  IF(HASONEVALUE('Table'[AccountID]),__Calc,BLANK())

You can also get there doing a similar thing with COUNTROWS('Table') and comparing to COUNTROWS(ALL('Table')) if they are the same, then you are in a total row. 

[amitchandak · Accepted solution]

@Sean-OReilly ,

add additional if in your filter

if( isfiltered(Table[Account]) , <Your formula> , blank())

or you can also try isinscope

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

[Sean-OReilly]

Thanks man - it worked