average from measure

[damj]

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 employes.

As an addition to  the measure, i want to be able to find the average of the circled number instead of the Total sum (ex 2,99)

Thank you in advance

[v-yalanwu-msft · Accepted solution]

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]

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]

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.