Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Total sum average for measure

Hi guys,   i have a measure doing this:   CALCULATE SUMX('DIO Calculation';SUMX('DIO Calculation';'DIO Calculation'[First Order Stock after 6 M])/'DIO Calculation'[Sales per day])   That bas...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Anonymous 

     

    Based on your description, I created data to reproduce your scenario.

    DIO Caculation:

     

    You may create a measure as below.

     

    Result = 
AVERAGEX(
    'DIO Calculation',
    'DIO Calculation'[First Order Stock after 6 M]/
    'DIO Calculation'[Sales per day]
)

     

     

    Result:

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous ,

Try like

divide(sum('DIO Calculation'[First Order Stock after 6 M]),sum('DIO Calculation'[Sales per day]))