Dynamic measure results based on a slicer selection

[Tlotly]

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

[Tlotly]

@amitchandak thank you so much. I used ISFILTERED as my slicers are different and it's working: Here is DAX:

IF(ISFILTERED(AreaDetails[Branch Name]),DISTINCTCOUNT(Arrears[Group Nr]) *0.07,

IF(ISFILTERED(AreaDetails[Region Name]),DISTINCTCOUNT(Arrears[Group Nr]) *0.12,

IF(ISFILTERED(AreaDetails[Zone Name]),DISTINCTCOUNT(Arrears[Group Nr]) *0.12,

DISTINCTCOUNT(Arrears[Group Nr]) *0.12))

)

[amitchandak · Accepted 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/