Forum Discussion
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 TRY and DKK and others. But RevenueSwitch doesnt work correctly, total doesn't show correct value and I cannot figure out why, thinking about it so long, please hepl me!
PowerBI desktop file has been upload here: https://drive.google.com/file/d/1MushunvO8Cx-1Lycg7v3663Dl9SsIuUW/view?usp=sharing
Thanks in advance for your help
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.
1 Reply
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.