DAX doubt

[Tarun_B9012]

I want to create a new measure or calculated column that counts the rows where the following conditions are met:

dsi_flag_cur_wk is “Red”
part_ww_dsi_flag is “Red”
cfg_ww_dsi_flag is “Red”
ack_flag is “Yes”
commit_act_chg is “Yes”

When these conditions are true, the value should be counted as 1. In your visualization, you want to see the total count of these rows.

Can someone please help me with the dax for this. 

[Tarun_B9012]

Thank you it worked. 

[lbendlin · Accepted solution]

=IF([dsi_flag_cur_wk] = “Red” &&
[part_ww_dsi_flag] = “Red” &&
[cfg_ww_dsi_flag] = “Red” &&
[ack_flag] = “Yes” &&
[commit_act_chg] = “Yes”,1,0)