Forum Discussion

lucie_rabochova's avatar
lucie_rabochova
Icon for Helper I rankHelper I
2 years ago
Solved

Currency Switcher doesn't work correctly

Hi all, Please help, I have Dashboard with 3 metrics, Revenue_DKK = Revenue value in DKK currency, Revenue_TRY = Revenue value in TRY Currency and then RevenueSwitcher using slicer to jump between T...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, lucie_rabochova 

    Based on the pbix file you provided me, I think you can change the DAX code for your SwitchRevenue Measure.

    Replace "TRY", DIVIDE(SUM(MetricsTable[Revenue_DKK]),MAX('CalculateCurrency'[TRY])) with "TRY", SUM(MetricsTable[Revenue_TRY])*1

    This will give you the result you want.

     

     

     

     

    How to Get Your Question Answered Quickly 

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, lucie_rabochova 

Based on the pbix file you provided me, I think you can change the DAX code for your SwitchRevenue Measure.

Replace "TRY", DIVIDE(SUM(MetricsTable[Revenue_DKK]),MAX('CalculateCurrency'[TRY])) with "TRY", SUM(MetricsTable[Revenue_TRY])*1

This will give you the result you want.

 

 

 

 

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.