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

Change Mensure

Hello everyone, 

 

I want to know, if is possible to change a mensure with a button or something like that.

 

For example:

 

I have a chart with the total amount (monetary) of sales. I want to put a button that I can change the mensure of this calc (showing the value in Dolar or in Euro). If I select Dolar, so the mensure is (Price*amount); if I select dolar, so it is: (Price*amount*Euro Value).

 

Sincerely, Luiz Bisco

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Change Mensure

@Bisco

 

You can do this with the help of a small parameter table.

Set up a new Table by manually entering data

 

Currency

Dollar

Euro

 

Now Create a slicer using this table. Then you can write a DYNAMIC MEASURE like

 

DYNAMIC_MEASURE =
IF (
    SELECTEDVALUE ( TableName[Currency] ) = "Dollar",
    YourMeasure1,
    IF ( SELECTEDVALUE ( TableName[Currency] ) = "EURO", YourMeasure2 )
)

See this post for more details

 

http://www.excelnaccess.com/power-of-values-function/

 

Try my new Power BI game Cross the River

View solution in original post

1 REPLY 1
Highlighted
Super User III
Super User III

Re: Change Mensure

@Bisco

 

You can do this with the help of a small parameter table.

Set up a new Table by manually entering data

 

Currency

Dollar

Euro

 

Now Create a slicer using this table. Then you can write a DYNAMIC MEASURE like

 

DYNAMIC_MEASURE =
IF (
    SELECTEDVALUE ( TableName[Currency] ) = "Dollar",
    YourMeasure1,
    IF ( SELECTEDVALUE ( TableName[Currency] ) = "EURO", YourMeasure2 )
)

See this post for more details

 

http://www.excelnaccess.com/power-of-values-function/

 

Try my new Power BI game Cross the River

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors