Forum Discussion

AaronGlenn10's avatar
AaronGlenn10
Helper III
4 years ago
Solved

Removing Page Filter for a Visual

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!

 

Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    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

3 Replies

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    4 years ago

    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