cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alekskr Frequent Visitor
Frequent Visitor

DAX switch between two ways of calculating measure.

Hi.

I have two measures for calculating sales margins, where one applies some corrections that might be useful.

I am wondering if it is possible to give the user the ability to choose which of the two ways he/she wants to use to calculate the sales margin in a report?

I am using analysis services database with live connection. 

1 ACCEPTED SOLUTION

Accepted Solutions
ryan_mayu Established Member
Established Member

Re: DAX switch between two ways of calculating measure.

@alekskr

 

You can see if the discussion in below subject can help you. Thanks

 

https://community.powerbi.com/t5/Desktop/how-to-make-column-optional-selective/td-p/593833

4 REPLIES 4
jthomson New Contributor
New Contributor

Re: DAX switch between two ways of calculating measure.

Yep, have a search on using a disconnected table to do so. Basically you put the options into a slicer, and then pull that selected value into a measure as a variable, which then returns the output of different measures based on what the variable is
ryan_mayu Established Member
Established Member

Re: DAX switch between two ways of calculating measure.

@alekskr

 

You can see if the discussion in below subject can help you. Thanks

 

https://community.powerbi.com/t5/Desktop/how-to-make-column-optional-selective/td-p/593833

alekskr Frequent Visitor
Frequent Visitor

Re: DAX switch between two ways of calculating measure.

Thanks. 
Are there any work-arounds to avoid having to make that extra table with the units in the datamodel ?

Highlighted
ryan_mayu Established Member
Established Member

Re: DAX switch between two ways of calculating measure.

@alekskr

 

Maybe you can try create two pages and use bookmark to switch the pages. In this way, you need to prepare two sets of visulizations.

 

Thanks

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 214 members 2,195 guests
Please welcome our newest community members: