- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you it worked.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=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)

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
04-19-2024 08:50 AM | |||
09-05-2024 10:59 PM | |||
06-23-2024 03:46 AM | |||
11-13-2021 02:42 AM | |||
06-13-2024 03:27 AM |
User | Count |
---|---|
27 | |
27 | |
25 | |
13 | |
10 |
User | Count |
---|---|
24 | |
19 | |
16 | |
13 | |
10 |