Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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! 😀👍
User | Count |
---|---|
136 | |
73 | |
73 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
63 | |
63 | |
51 |