Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hi all,
I was hoping someone could assist me with a DAX query as I have fairly basic knowledge of it.
What would be the formula if I would like to COUNT number of rows if the conditions for the following columns are met:
[assignment_group] = "Site Survey - Area C", "Site Survey - South Flank" and "Site Survey - Yandi"
[Site Survey - Rework] = "TRUE"
Any help would be greatly appreciated. Thanks!
Solved! Go to Solution.
Hi @Sanctuarius ,
Please try this:-
measure_ =
COUNTROWS (
FILTER (
'table',
'table'[assignment_group]
IN { "Site Survey - Area C", "Site Survey - South Flank", "Site Survey - Yandi" }
&& 'table'[Site Survey - Rework] = "TRUE"
)
)
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi @Sanctuarius ,
Please try this:-
measure_ =
COUNTROWS (
FILTER (
'table',
'table'[assignment_group]
IN { "Site Survey - Area C", "Site Survey - South Flank", "Site Survey - Yandi" }
&& 'table'[Site Survey - Rework] = "TRUE"
)
)
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi @Samarth_18 ,
Thank you for your quick response.
Apologies if this is a stupid question as I'm new to all this, but do I have to create a New table for this DAX expression or this can be created with a New measure? What is the 'table' parameter?
@Sanctuarius , kindly replace table with your actual table name.
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Awesome! Thank you very much for your help! 😀👍