Forum Discussion
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...
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.
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.