Reply
Frequent Visitor
Posts: 10
Registered: ‎11-08-2018
Accepted Solution

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. 


Accepted Solutions
Established Member
Posts: 183
Registered: ‎09-17-2018

Re: DAX switch between two ways of calculating measure.


All Replies
Highlighted
Super User
Posts: 443
Registered: ‎07-12-2017

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
Established Member
Posts: 183
Registered: ‎09-17-2018

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

Frequent Visitor
Posts: 10
Registered: ‎11-08-2018

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 ?

Established Member
Posts: 183
Registered: ‎09-17-2018

Re: DAX switch between two ways of calculating measure.

[ Edited ]

@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