SUMX or SUM produce wrong result

[Anonymous]

Hi all,

I'm having trouble with SUMX or SUM. It appears both deliver wrong (but same) result when I sum 4 columns in the same table. I believe it's related to commas in my numbers. You can see sample of the columns I'm Summing below:

https://docs.google.com/spreadsheets/d/1oum6QkO6MgzApr2rsGgv5zg6VVCeNN1SU8CaNBlvPdg/edit?usp=sharing

My measure with SUMX and SUM deliver the same result, see them below:

FBrevenueOfflineOnlineSUM = SUM('Facebook BM Attribution'[Website Purchases Conversion Value [1 Day After Viewing]]]) + SUM('Facebook BM Attribution'[Website Purchases Conversion Value [1 Day After Clicking]]]) + SUM('Facebook BM Attribution'[Offline Purchases Conversion Value [28 Days After Viewing]]]) + SUM('Facebook BM Attribution'[Offline Purchases Conversion Value [28 Days After Clicking]]])

FBrevenueOfflineOnlineSUMX = SUMX('Facebook BM Attribution', 'Facebook BM Attribution'[Website Purchases Conversion Value [1 Day After Viewing]]] + 'Facebook BM Attribution'[Website Purchases Conversion Value [1 Day After Clicking]]] + 'Facebook BM Attribution'[Offline Purchases Conversion Value [28 Days After Viewing]]] + 'Facebook BM Attribution'[Offline Purchases Conversion Value [28 Days After Clicking]]])

Let me know what I might be doing wrong. Appreciate your time and help!

Kind regards,

Ivan

[V-pazhen-msft · Accepted solution]

Hi, @Anonymous 

I have tested with your data and formula have, they work fine.
Regarding to commas, it is important to know that Power BI cannot read decimal commas, you need to change your commas to decimal point.

Paul

[Anonymous]

Thank @V-pazhen-msft , I'll keep that in mind when working with my data sources.

Appreciate your time and help!

Ivan