Forum Discussion

pmadam's avatar
pmadam
Icon for Helper II rankHelper II
5 years ago

DAX HELP

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(...
DAX ALL PowerBI Excel
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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 )))