Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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?
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?
User | Count |
---|---|
51 | |
27 | |
19 | |
18 | |
14 |
User | Count |
---|---|
91 | |
86 | |
39 | |
23 | |
22 |