Incident Data

[Anonymous]

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

[Rujohn]

Hi,

I am new here. I need help.

IF(Incident[Age of Incident]<7,COUNT(Incident[Incident Number]))

^^above is fine (no errors when I saved). this is to calculate the age LESSER THAN 7.

How do I write below?

Age is GREATER THAN 7 BUT IS LESSER THAN 14?

[jthomson]

Strange bump, but try this:

IF(Incident[Age of Incident]<14&&Incident[Age of Incident]>7,COUNT(Incident[Incident Number]))

[Rujohn]

thank you sir. It worked! you're the best!

[parry2k · Accepted solution]

@Anonymous The best approach would be to have another table with location and the capacity and set relationship between your daily incident table wth this new table to calculate the %