Measure with switch with thousant, millions shows wrong sum in matrix

[zerebro]

I want in a matrix show the values in "Default Value","Thousands" and "Millions", it works but the total amount is not right, if i have 228.000 from the original value the measure shows 266.000.

Help plz...

MeasureAnalysisLastFullYear =

SWITCH (

SELECTEDVALUE ( Units[MeasureUnit] );

"Default Value"; SUM('vAnalysisLastFullYear'[SumLocalCurrencyAmount]);

"Millions"; DIVIDE(SUM ( 'vAnalysisLastFullYear'[SumLocalCurrencyAmount] );1000000);

"Thousands"; DIVIDE(SUM ( 'vAnalysisLastFullYear'[SumLocalCurrencyAmount] );1000); SUM('vAnalysisLastFullYear'[SumLocalCurrencyAmount])

)

[v-cherch-msft]

Hi @zerebro 

I would suggest you create a measure like below to check if this measure's total is correct.If it is not your case,please refer to How to Get Your Question Answered Quickly to share your sample data which could reproduce your scenario and your desired output.

Measure =
SUMX ( 'vAnalysisLastFullYear', [MeasureAnalysisLastFullYear] )

Regards,

[zerebro]

Now i tried that but the sum is 265 when it shuld be 228...

Is there any "hidden" rows that are included in the sum?

[v-cherch-msft]

Hi @zerebro 

Without looking at sample data,it is very hard to provide an accurate solution.Please check if the workaround in below post could help you.

https://community.powerbi.com/t5/Desktop/Grand-total-not-showing-the-result-I-was-expecting/m-p/6378...

Regards,