Change Mensure

[Bisco]

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

[Zubair_Muhammad · Accepted solution]

@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/