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.

     

v-alq-msft's avatar
v-alq-msft
Community Support
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.