Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Tlotly
Resolver II
Resolver II

Dynamic measure results based on a slicer selection

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

AreaBudget%
Region 0.12
Zone0.07
Branch

0.07

 

slicers

Tlotly_0-1636984187517.png

 

Can you please help on how to achieve this?

 

Thank you

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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/

View solution in original post

2 REPLIES 2
Tlotly
Resolver II
Resolver II

@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
Super User
Super User

@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/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.