Reply
Tarun_B9012
New Member

DAX doubt

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. 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

=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)

View solution in original post

2 REPLIES 2
Tarun_B9012
New Member

Thank you it worked. 

lbendlin
Super User
Super User

=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)

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)