Calculate with multiple conditions

[Anonymous]

Hi ,

I am calculte a factor for safety management. I need to add 3 conditions:

Lost Time Injury

Medical Aid

First Aid - Treatment 

When I add only one condition, it works good.

A = CALCULATE(COUNT('Incident Report'[Form ID]),

'Date',

'Incident Report'[Event Type]="Lost Time Injury")

Once I add three conditions, it shows blank, but it shouldn't.

A = CALCULATE(COUNT('Incident Report'[Form ID]),

'Date',

'Incident Report'[Event Type]="Lost Time Injury",

'Incident Report'[Event Type]="Medical Aid",

'Incident Report', 'Incident Report'[Event Type]="First Aid - Treatment")

I can't find the reason. Please help!!!

[vapid128 · Accepted solution]

A = 
CALCULATE(
    COUNT('Incident Report'[Form ID]),
    Filter('Incident Report',
        'Incident Report'[Event Type]="Lost Time Injury" ||
        'Incident Report'[Event Type]="Medical Aid" ||
        'Incident Report', 'Incident Report'[Event Type]="First Aid - Treatment"
)

I don get what is 'Date', do you want sum workers and days?