Forum Discussion

peterhui50's avatar
peterhui50
Helper III
2 years ago

Calculation group PAGE LEVEL FILTER selection

I have a measure here,

 

Totals_FTE = CALCULATE ( SUM(FTE), KEEPFILTERS(Company = "AAA"))

Totals_Bum_Seats = CALCULATE ( SUM(Bum_in_Seats ), KEEPFILTERS(Company = "AAA"))

 

I want it to switch between FTE and Bum_in_Seats so I build a Calculation group item

 

Totals_item = CALCULATE( SELECTEDMEASURE(),

KEEPFILTERS(Company = "AAA"))

 

It seems to work, but is there a way for users to select as a PAGE LEVEL FILTER and they can toggle between the two ? FTE and BUM_in_Seats

 

1 Reply