Forum Discussion

damj's avatar
damj
Frequent Visitor
3 years ago
Solved

average from measure

Hi. Hopefully someone can help me with this problem. i have made a measure from the data table shown to the left. the measure is simply made from the sum of sick days divided by the number of empl...
Need Help
Tips and Tricks
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, damj ;

    You could try to change it.


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

Hi, damj ;

You could try it.

Measure = 
AVERAGEX(SUMMARIZE('Table',[Date],[L evel],"1",
SUM('Table'[Sickdays])/AVERAGEA('Table'[NumberOfEmployes])),[1])

The final show:

Or you could add more column in summarize which according to your need.

Measure = 
AVERAGEX(SUMMARIZE('Table',[Date],[L evel],[L evel]...,"1",
SUM('Table'[Sickdays])/AVERAGEA('Table'[NumberOfEmployes])),[1])


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

damj's avatar
damj
Frequent Visitor
3 years ago

HI v-yalanwu-msft

thank you for your solution, but i its like the column doesn't sum up according to days/month/year.

It puts out some data, but not the intended.

On the top right arrow - This is the expected data on the left and result from measure on the right.

The buttom arrow seems to average the total amount, but is wrong due to the last mentioned problem.

Although on your illustration it seems to be correct.

Hope you can help with my issue.