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.
I don't have it. But i can give you the example.
Dimension : Immediate_cause
Measure : Count (Immediate_cause_1) + (Immediate_Cause_2) + (Immediate_Cause_3)
But it gave me 0 value in return.... 😞
Do something like this:
For your case:
if Count (Immediate_cause_1) is your first expression, then this will be column(1).
Count(Immediate_Cause_2) should be your second expression, then this will be column(2).
Count(Immediate_Cause_3) should be your third expression, then this will be column(3).
So your last expression will looks like:
it workssss! But how do i add the condition to only count accident only. Because it doesn't allow me to do nested count.
Right now, the calculation for calculating one measure which is Immediate_cause_1 is :
Try this maybe: