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 OccupancySta...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Hi KarenKazab 

     

    No' Tenants =
COUNTROWS (
    FILTER (
        'CurrentOccupants',
        'CurrentOccupants'[OccupancyStatus] IN { "Lead", "Joint" }
    )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

Hi KarenKazab 

 

No' Tenants =
COUNTROWS (
    FILTER (
        'CurrentOccupants',
        'CurrentOccupants'[OccupancyStatus] IN { "Lead", "Joint" }
    )
)
KarenKazab's avatar
KarenKazab
Frequent Visitor
7 years ago

Thanks Zubair_Muhammad  you're a star. So easy when you think about it.