Sum of percentages

[korina]

Hello all,

I have the table below, and I am trying to sum the Attrition Rate percentages (as in 0.9+1.9 = 2.8, rather than having a recalculated value based on Average Leavers and Average Headcounts).

My end goal is a rolling 3-month attrition (and being able to filter by the filters shown). I have gotten as close as possible with the formula you will see in my workbook, but the calculation is not 100% correct. If Region is set to UK, it should be 4.4% instead of 4%. If Region is set to UK and Division is set to B, it should be 4.2% instead of 3.8%.

My test pbix: Attrition Tests

Any ideas would be very much appreciated 🙂

[korina]

Hello HotChilli,

Thank you so so much for this! It works amazingly.

I added the month bit as part of the measure, as I need the 6 month, and 12 month rolling attrition as well.

[HotChilli · Accepted solution]

In an attempt to keep thing simple, I created this measure:

TestM = SUMX(VALUES(Dates[Date]), [Attrition Rate])

and then using the filter pane, limited it to the last 3 months using a relative date filter. I think it gets the correct answers.

-

I suggest testing at your side and you could maybe incorporate the 'last 3 months' part in the measure if you don't want to use the filter pane.

Let me know how you get on.