Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |