COUNT Formula with Multiple Criteria

[Sanctuarius]

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!

[Samarth_18 · Accepted 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

[Sanctuarius]

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?

[Samarth_18]

@Sanctuarius , kindly replace table with your actual table name.

[Sanctuarius]

Awesome! Thank you very much for your help! 😀👍