cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alekskr
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 Impactful Individual
Impactful Individual

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

Did I answer your question? Mark my post as a solution.Appreciate your Kudos!
Proud a to be a Datanaut!
Thanks and BR
Ryan

View solution in original post

4 REPLIES 4
Highlighted
jthomson Solution Sage
Solution Sage

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 Impactful Individual
Impactful Individual

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

Did I answer your question? Mark my post as a solution.Appreciate your Kudos!
Proud a to be a Datanaut!
Thanks and BR
Ryan

View solution in original post

alekskr
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 ?

ryan_mayu Impactful Individual
Impactful Individual

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

Did I answer your question? Mark my post as a solution.Appreciate your Kudos!
Proud a to be a Datanaut!
Thanks and BR
Ryan

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors