I have a table representing Accidents and a column with Accident Severity ranging from 'Slight' to 'Fatal'. I want to create a measure counting Fatal Accidents depending on other columns on the Accidents table and others (Road Type, Weather Conditions etc.)
What would the calculated member for this measure be and would adding it to a Fact Table consisting of Foreign Keys from all those tables be enough to accomplish what I want?
Best Answer
Assuming you already have designed
Total
that counts the accidentsSeverity
that describes the severity of the accidentyou can define a calculated member such as: