Extracted measure in excel has different value as compared to same table in powerBI

[Lubomirds]

Hello

i build table in powerBI, and get it extracted to excel, via extract data option in table in PowerBI

Data in table is less than 30 K rows.

Inside the table i have measure, created inpower BI, calculating delta between demand and forecast - Bias

When i extract data and sum this measure in excel  (forecast bias), it is giving result different from what i see in power BI - same table, same granularity of the data

[amitchandak]

@Lubomirds , Power BI recalculate Grand totals, so if some context has been used to calculate the measure, it may not sum up correctly.

You need use sumx with values or summarize for that

refer: https://community.powerbi.com/t5/Desktop/Grand-Total-in-Bar-Chart/m-p/612631

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