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 Solution Supplier
Solution Supplier

Re: DAX switch between two ways of calculating measure.

4 REPLIES 4
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 Solution Supplier
Solution Supplier

Re: DAX switch between two ways of calculating measure.

Highlighted
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 Solution Supplier
Solution Supplier

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
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

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

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors