Multiple group by/ranking issue

I have a faily simple data issue, which seems like it could be complicated in Power BI, but I'm a relative newbie so I'm hoping someone can point me in the right direction.

Here's the overview: I have data which includes multiple plants, each plant has multiple wind turbines, and each turbine has multiple alarms which go off on a daily basis. What I need to do is this:

1. Count how many alarms went off per plant per day, by alarm type.

2. Find the top n (in this simple case n = 2) alarms, by plant, for any date range the user selects.

3. Once we know which were the top 2 alarms for each plant, we need to then figure out which turbine(s) had the most instances of that alarm go off in the same time period. 

4. The final output is basically Plant Name, Alarm Code, # of alarms, and Turbine(s) most impacted. That would look like this:

Here's how the data flow would work from start to finish:

First, the raw data. This is just 2 days with 2 plants, 3 alarms and 3 turbines per plant:

So the next step is to count total number of alarms per plant for the given date range. Ultimately, we only care about the top 2 for each plant:

We now need to count the total number of alarms per turbine, to know which match up with our most common alarms:

Now we need only those which were part of the most common alarms (AC1, AC2):

And then again, the final data set which shows the most common alarms per plant, with a column for the turbine(s) which were most affected by those alarms:

I feel like this shouldn't be too difficult to do, it took about 2 minutes wo work up Access queries to show the data I need, but the tricky part is dealing with selecting any date range to begin with. In my example here it's just 2 days and I selected them both, but in reality we'll have year(s) worth of data and the user should use a slider to pick any date range they want, and then these same calculations need to happen.

Thank you so much if you can help!

thanks

Alex