Forum Discussion
Turn 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/
3 Replies
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/
Thanks man - it worked
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.
