Hello all!
I am trying to get the total sum of a table, which has values in different currencies (ARS, CLP and UYU).
I started studying DAX last week and I was able to get the correct sum per month, but the subtotals are not working.
Basically...
I have a table with the conversion of each currency to dollar:
To get only ARS values, I used:
Convert ARS to USD:
And to get the final value:
The problem: the result per line appears correct, but the subtotal does not.
1) How do I get the correct subtotal (USD 8,215,067.05)?
2) Seizing the opportunity ... What can I optimize this conversion?
Can someone help me?
Example: https://drive.google.com/file/d/1qS0HxqA_ev6tGogejVhxMSwdVJf_Uory/view?usp=sharing
I am trying to get the total sum of a table, which has values in different currencies (ARS, CLP and UYU).
I started studying DAX last week and I was able to get the correct sum per month, but the subtotals are not working.
Basically...
I have a table with the conversion of each currency to dollar:
To get only ARS values, I used:
Code:
[COLOR=#8B8B8B][FONT=Menlo]Total_Orçado_ARS = SUMX(FILTER(Arg_Orcado;Arg_Orcado[Currency]="ARS");Arg_Orcado[ValorOrçado])[/FONT][/COLOR]Convert ARS to USD:
Code:
[COLOR=#8B8B8B][FONT=Menlo]Convert_ARS_USD = SUMX(FILTER(db_Currency;db_Currency[LocalCurrency]="ARS");db_Currency[Factor])[/FONT][/COLOR]And to get the final value:
Code:
[COLOR=#8B8B8B][FONT=Menlo]Total_ARS_USD = DIVIDE([Total_Orçado_ARS];[Convert_ARS_USD];0)[/FONT][/COLOR]The problem: the result per line appears correct, but the subtotal does not.
1) How do I get the correct subtotal (USD 8,215,067.05)?
2) Seizing the opportunity ... What can I optimize this conversion?
Can someone help me?
Example: https://drive.google.com/file/d/1qS0HxqA_ev6tGogejVhxMSwdVJf_Uory/view?usp=sharing
