Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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...
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |