Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Avg/day/store

Hi All, I'm trying to calculate Avg/day/store but, my number are not coming out correctly. Is anything wrong with my DAX.   
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Please refer this measure:

    Measure =
AVERAGEX ( ALLEXCEPT ( 'dim', 'dim'[store] ), [units sold] ) / 7

    If it doesn't work, please share some sample data.

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

Please refer this measure:

Measure =
AVERAGEX ( ALLEXCEPT ( 'dim', 'dim'[store] ), [units sold] ) / 7

If it doesn't work, please share some sample data.

 

Best Regards,

Jay