cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Sum of percentages

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 🙂

1 ACCEPTED SOLUTION
Super User

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.

2 REPLIES 2
Helper I

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.

Super User

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.