Numbers Not Adding Up

[joshs444]

I tried to validate the number I was getting from a measure in Power BI in excel.

I took the tables and ran the necessary formulas, however I got a slightly different number.

The formulas looked sound, so I exported the table with the data I was trying to validate into excel.

Then I noticed something strange. the number for "Total" in Power BI, is different than the sum in the export in excel.

When I export it into excel, the correct number is the sum, but in power BI, it is off.

This is the sum of the exported column in excel (which is the correct number)

Any idea why the numbers arent matching up? 555 is the correct number based on the table data.

I am confused, any help is appreciated.

Thanks!

[amitchandak · Accepted solution]

@joshs444 , You might be using row context. You need to use values or summarize to correct total

example

Sumx(Values(Table[Viual COlumn]), [Meausre])

refer: https://www.youtube.com/watch?v=ufHOOLdi_jk