add 3 columns in one measure

[nurulizzaty]

Hello experts,

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.

Regards,

Zety. 

[nurulizzaty]

It worksssss! Thank you soooo muchhhh! :))))))) Appreciate it a lot 🙂

[Arthur_Fong]

Appreciate if you can accept the above as solution.

Thanks and regards,

Arthur Fong

[nurulizzaty]

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 😞

[Arthur_Fong]

You would need to provide more info so that we can help:

What is the condition for Immediate_cause_2?

What is the condition for Immediate_cause_3?

[Arthur_Fong]

If the conditions are the same, maybe try this:

Count({$<[IIR_INCIDENTMAIN_1.INCIDENT_TYPE]={'Accident'}>}[IIR_INCIDENTMAIN_1.IMMEDIATE_CAUSES_1])+

Count({$<[IIR_INCIDENTMAIN_1.INCIDENT_TYPE]={'Accident'}>}Immediate_Cause_2)+

Count({$<[IIR_INCIDENTMAIN_1.INCIDENT_TYPE]={'Accident'}>}Immediate_Cause_3)

[nurulizzaty]

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? 

[Arthur_Fong]

It depends on your data model and what your requirement looks like.

Do provide more info on your requirements.