cancel
Showing results for
Did you mean:
Helper 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

 Area Budget% Region 0.12 Zone 0.07 Branch 0.07

slicers

Thank you

1 ACCEPTED SOLUTION
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/

Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
!! Subscribe to my youtube Channel !!
2 REPLIES 2
Helper II

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

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

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/

Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
!! Subscribe to my youtube Channel !!

Announcements

#### The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

#### Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

#### Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!