Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi,
I have two tables and they are connected.
In Table A, Client ID is unique but in Table B it is not.
Now I want to count the number of rows in Table A that have client ID existed in Table B. I'd like to use "countrows" function instead of "distinctcount" for another calculation purpose. Does any one know how to do it?
Thanks a lot in advance!!
Solved! Go to Solution.
Hi @Ying_P,
You can create a measure below:
Measure = COUNTROWS(FILTER('Table A',CONTAINS('Table B',[Client ID],'Table A'[Client ID])))
Best Regards,
Qiuyun Yu
Hi @Ying_P,
You can create a measure below:
Measure = COUNTROWS(FILTER('Table A',CONTAINS('Table B',[Client ID],'Table A'[Client ID])))
Best Regards,
Qiuyun Yu
So what should we do if we wanted to return only certain values from table B? For example, what should we do if we wanted to filter client IDs with Product Category ID = 'Kids Tops'?
So simple! Thank you. I added a + 0 at the end to avoid blank when there is no match.
Thank you very much,. It works perfectly!
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.