cancel
Showing results for
Did you mean:
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

## 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
Highlighted
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

Announcements

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### July 2020 Community Highlights

Learn about the exciting things that happened in July.

#### Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

#### Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.