Forum Discussion

Bisco's avatar
Bisco
Frequent Visitor
8 years ago
Solved

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 ...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    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/

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

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/