DAX HELP

[pmadam]

I am calculating Avg value measure , it works fine with below dax but total of that measure is 43.4 but when i export to excel its giving 42.80.

Please guide me 

Avg IN GP% = CALCULATE( AVERAGE('IN - Sales'[Ship GP% - SALE]), FILTER('IN - Sales',[Ship GP% - SALE] <> 0 ))

[amitchandak]

@pmadam , excel uses simple avg or lines.

Say your data is at ID, region level. This 43.4 is avg for Id level.

Assume you exported data at the region level. Excel will show avg of that data from region level

here you can get that like

Avg IN GP% = Averagex('IN - Sales'[region]), CALCULATE( AVERAGE('IN - Sales'[Ship GP% - SALE]), FILTER('IN - Sales',[Ship GP% - SALE] <> 0 )))