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('IN - Sales'[Ship GP% - SALE]), FILTER('IN - Sales',[Ship GP% - SALE] <> 0 ))

DAX ALL PowerBI Excel

1 Reply

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