Forum Discussion

peterhui50's avatar
peterhui50
Icon for Helper III rankHelper 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 b...
Need Help
Tips and Tricks
Tutorial Requests
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

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