Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All
I'm trying to create a measure (% of budget)that will give different results based on which slicer is selected. I have 3 different slicers i.e. Region, Zone and Brach all of which use different budgets. So for example if I select a Branch my calculation needs to be:
sum([Nr.of Groups])*0.07 and if I select Region it needs to be: sum([Nr.of Groups])*0.12
budgets
Area | Budget% |
Region | 0.12 |
Zone | 0.07 |
Branch | 0.07 |
slicers
Can you please help on how to achieve this?
Thank you
Solved! Go to Solution.
@Tlotly , do you have filter which return region , Zone and branch if yes then you measure will be
Switch( Selectedvalue(Table[Type], "Region"),
"Region", sum([Nr.of Groups])*0.12,
"Branch",sum([Nr.of Groups])*0.07,
sum([Nr.of Groups])
)
If this should be based on the selected value of three different slicers, then you need to use isfiltered
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
@amitchandak thank you so much. I used ISFILTERED as my slicers are different and it's working: Here is DAX:
@Tlotly , do you have filter which return region , Zone and branch if yes then you measure will be
Switch( Selectedvalue(Table[Type], "Region"),
"Region", sum([Nr.of Groups])*0.12,
"Branch",sum([Nr.of Groups])*0.07,
sum([Nr.of Groups])
)
If this should be based on the selected value of three different slicers, then you need to use isfiltered
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |