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 guys,
I have 2 tables with UserID. Table A contains all UserID while Table B contains UserIDs that are not active.
I will like to count USERIDs in TableA which are not included in TableB so as to know the number of active user.
Thanks a lot in advance!!!
Best regards
COUNTROWS(EXCEPT(TableA, TableB))
Thanks a lot! It dint't work exactly but your idea gave me a way to search for the right context.
I found the answer through this: https://community.powerbi.com/t5/Desktop/How-to-count-rows-that-are-related-to-another-table/m-p/199...
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 |
---|---|
39 | |
20 | |
19 | |
16 | |
15 |
User | Count |
---|---|
47 | |
28 | |
25 | |
17 | |
17 |