Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Bisco
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
Zubair_Muhammad
Community Champion
Community Champion

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

 


Regards
Zubair

Please try my custom visuals

View solution in original post

1 REPLY 1
Zubair_Muhammad
Community Champion
Community Champion

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

 


Regards
Zubair

Please try my custom visuals

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.