Forum Discussion

GHerz's avatar
GHerz
Frequent Visitor
4 years ago
Solved

New challenge for Dynamic Measures

Dear Power BI Experts, I have searched through the community and other sources several time, but can't find a solution for below, there I appreciate any wise comment on this:   With Tabular editor...
  • DataInsights's avatar
    4 years ago

    GHerz,

     

    You can get the selected Currency with SELECTEDVALUE:

     

    SELECTEDVALUE ( CurrencyTable[Currency] )

     

    You can identify the selected measure with ISSELECTEDMEASURE:

     

    ISSELECTEDMEASURE ( [Revenue] )

     

    Use these expressions in a SWITCH statement to determine which measure to use.