Forum Discussion
Sean-OReilly
Helper IV
Helper IVTurn Off a Total from a Table Visual
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?
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/
amitchandak
Super User
Super Useradd 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-OReillyHelper IV
Helper IVThanks man - it worked