Forum Discussion

KarenKazab's avatar
KarenKazab
Frequent Visitor
7 years ago
Solved

Dax formula help - count rows with multiple values in one column

Hi all,

 

Relatively new to power bi and Dax and i'm sure this is probably an easy one, in sql would be a doddle, i want to count the rows in my table CurrentOccupants where the column OccupancyStatus is equal to Lead and Joint so something like:

 

No' Tenants = COUNTROWS(FILTER('CurrentOccupants','CurrentOccupants'[OccupancyStatus] = "Lead","Joint"))

 

I've tried searching and cant seem to find a solution to this.

 

Many thanks 

 

Karen

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Hi KarenKazab 

     

    No' Tenants =
COUNTROWS (
    FILTER (
        'CurrentOccupants',
        'CurrentOccupants'[OccupancyStatus] IN { "Lead", "Joint" }
    )
)

3 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    7 years ago

    Hi KarenKazab 

     

    No' Tenants =
COUNTROWS (
    FILTER (
        'CurrentOccupants',
        'CurrentOccupants'[OccupancyStatus] IN { "Lead", "Joint" }
    )
)
    • ainie's avatar
      ainie
      Regular Visitor
      3 years ago

      Hi Zubair,

       

      I tried your solution but received syntax error. May i know what could be wrong? I'm newbie in DAX PBI. Appreciate your help on this. Thanks!

       

      Total Submission = CALCULATE (COUNTROWS ( node__field_state ), node__field_state[field_state_value IN { "processing","accepted","draft","rejected" }))