Wrong total amount in a Matrix table

[Anonymous]

Hello everyone,

I'm having a problem with this messure when using a table, I'm not getting the total of the column.

Can anyone help me with this "formula" ?

I'm using this measures to calculate the currency value.

Sales PY = VAR V_LIQ_PY = IF(SUM(PBI_AFR_Parts[$_Venda Líquido])=0;BLANK();CALCULATE(SUM(PBI_AFR_Parts[$_Venda Líquido]);SAMEPERIODLASTYEAR('_Calendário'[Data])))

VAR CAMBIO_PY = CALCULATE(SUM(PBI_AFR_Cambios[Cambio]);SAMEPERIODLASTYEAR('_Calendário'[Data]))

RETURN

SWITCH(TRUE();

[SELECT MOEDA]="AOA";DIVIDE(V_LIQ_PY;CAMBIO_PY;BLANK());

[SELECT MOEDA]="EUR";DIVIDE(V_LIQ_PY;CAMBIO_PY;BLANK());

[SELECT MOEDA]="USD";DIVIDE(V_LIQ_PY;CAMBIO_PY;BLANK());

[SELECT MOEDA]="CVE";DIVIDE(V_LIQ_PY;CAMBIO_PY;BLANK());

[SELECT MOEDA]="MZN";DIVIDE(V_LIQ_PY;CAMBIO_PY;BLANK());

[SELECT MOEDA]="KES";DIVIDE(V_LIQ_PY;CAMBIO_PY;BLANK());

[SELECT MOEDA]="FCFA";DIVIDE(V_LIQ_PY;CAMBIO_PY;BLANK());

V_LIQ_PY)

and 

Sales CY = VAR V_LIQ_CY = SUM(PBI_AFR_Parts[$_Venda Líquido])

VAR CAMBIO_CY = SUM(PBI_AFR_Cambios[Cambio])

RETURN

SWITCH(TRUE();

[SELECT MOEDA]="AOA";DIVIDE(V_LIQ_CY;CAMBIO_CY;BLANK());

[SELECT MOEDA]="EUR";DIVIDE(V_LIQ_CY;CAMBIO_CY;BLANK());

[SELECT MOEDA]="USD";DIVIDE(V_LIQ_CY;CAMBIO_CY;BLANK());

[SELECT MOEDA]="CVE";DIVIDE(V_LIQ_CY;CAMBIO_CY;BLANK());

[SELECT MOEDA]="MZN";DIVIDE(V_LIQ_CY;CAMBIO_CY;BLANK());

[SELECT MOEDA]="KES";DIVIDE(V_LIQ_CY;CAMBIO_CY;BLANK());

[SELECT MOEDA]="FCFA";DIVIDE(V_LIQ_CY;CAMBIO_CY;BLANK());

V_LIQ_CY)

and this is what I get, all the months are correct but the tatal amount is not...

Please help me !

[Greg_Deckler · Accepted solution]

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907