I would like count three columns all together to be in one measure. Is it possible to do that?
Really need your insights.
Thanks in advance.
sorryy, but the value does not accurate.....
because the condition is to check if it is accident or not. The expression that you gave only applies at Immediate_cause_1. while the Immediate_cause_2 and Immediate_cause_3 does not follow the condition 😞
If the conditions are the same, maybe try this:
Yes, the condition is the same. But, seems like it counts different value because of the dimension.
What should i put in the dimension? Do i need to just input Immediate cause 1 or include everything (Immediate cause 2 + Immediate cause 3) all together?