DAX switch between two ways of calculating measure.

[Anonymous]

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. 

[ryan_mayu · Accepted solution]

@Anonymous

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

[Anonymous]

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

[ryan_mayu]

@Anonymous

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

[jthomson]

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