Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |