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
Solved! Go to Solution.
Hi @KarenKazab
No' Tenants = COUNTROWS ( FILTER ( 'CurrentOccupants', 'CurrentOccupants'[OccupancyStatus] IN { "Lead", "Joint" } ) )
Hi @KarenKazab
No' Tenants = COUNTROWS ( FILTER ( 'CurrentOccupants', 'CurrentOccupants'[OccupancyStatus] IN { "Lead", "Joint" } ) )
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!
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
107 | |
74 | |
66 | |
50 | |
49 |
User | Count |
---|---|
163 | |
85 | |
76 | |
68 | |
67 |