Incident Data

I have a spreadsheet with incident data (one incident per row). Information captured on each row includes the location of the incident and the type of incident. 

At the moment, the PowerBI report I create from this spreadsheet counts each type of incident and how many per hotel etc.

HOWEVER 

each location has different capacities therefore a particular location with lots of incidents may just look higher because the capacity is higher to begin with.

I am able to obtain the capacity numbers per location.

My question is, how would I go about capturing this data so the PowerBI report shows some sort of ratio/percentage/average based on the capacity and the incident numbers?

Could I do this within PowerBI or would I have to create another spreadsheet and if so, what's the best way to do this? 

As the incident spreadsheet is being updated daily, I ideally wanted the report to feed from this so I can just refresh and won't have to extract data every week or so.

Hope the above makes sense and any help would be great :) 

Thanks