Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

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.