Removing Page Filter for a Visual

[AaronGlenn10]

All Stars:

Trying to remove a page filter for two visuals -- the page filter is for cities [which applies across multiple pages], but would like to sum the calculation for all cities to arrive at a Total State calculation so I can comapre the selected city to the total State.

Please see screenshot below.  Thank you!

[Samarth_18 · Accepted solution]

Hi @AaronGlenn10 ,

Try to use ALL() or AllExcept() in your calculation to avoid such filter on your calculation like calculation(sum(sales),all(filter_table[column))

Thanks,

Samarth

[AaronGlenn10]

This worked!  Thank you so much!

[Anonymous]

hi. @AaronGlenn10 you can use edit interactions