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,
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!
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 |
---|---|
116 | |
102 | |
78 | |
77 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |