Forum Discussion

Sanctuarius's avatar
Sanctuarius
New Member
4 years ago
Solved

COUNT Formula with Multiple Criteria

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 t...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    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's avatar
Sanctuarius
New Member
4 years ago

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's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
4 years ago

Sanctuarius , kindly replace table with your actual table name.

  • Sanctuarius's avatar
    Sanctuarius
    New Member
    4 years ago

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