Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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/
User | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |