# Subtotal Problem

#### DalPai

##### New Member
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:
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?

### Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Replies
4
Views
204
Replies
0
Views
175
Replies
0
Views
1K
Replies
8
Views
8K
Replies
1
Views
86

1,195,856
Messages
6,011,976
Members
441,661
Latest member
Pammie007

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back