Forum Discussion
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
- amitchandakSuper User
peterhui50 , Try if Field parameters can help in that case
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf
Power BI Field Parameters, Keep Axis Sort intact| Always Sort on X/Categorial Axis: https://youtu.be/GfBrB6czByw