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

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
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! 😀👍