Forum Discussion
Error with currency conversion
Hello everyone.
at this moment I am working on a report in which I have monetary information of several countries each with its respective local currency, I have already parameterized a measure that converts the currencies according to the countries I select to USD. But now I need to calculate the total sum according to a series of parameters. My measure looks like this.
This measure works for me as long as I select in my country filter all, but if I select only one it shows me only the sum of that country. I thought about using the following measure, but with this one I have problems converting to USD (with the previous measurement if it works for me.
To perform the conversion I am using the following measure, but this fails when I use removefilters. I appreciate any help in trying to resolve this situation.
1 Reply
- amitchandak
Super User
Syndicate_Admin , refer ths blog on same topic can help
https://www.sqlbi.com/articles/currency-conversion-in-power-bi-reports/