filter in pages and slicer

[Anonymous]

Hi, there are filters in pages to get relevant data, and I need to create divide calculation in every pages,

the calculation = divide(calculation(sum(A),..) ,calculation(sum(B),..))
the sum of B should return the overalll value(negelect fiter in pages) and consider the context to change with slicer,

how to keep the filters in different pages and get the right data of denominator value( sum of B)? Thank you.

[amitchandak · Accepted solution]

@Anonymous , Try if removefilters or all can help

calculate(sum(B), removefilters(Table[Col]))

or

calculate(sum(B), all(Table[Col]))