How to count the number of names within a category in a table

[waly01]

Hi, 

I have 2 tables. One table is laid out with a Company name in one column and a total items sold in another column. 

I have a second table that just has Client who purchased the item and the amount it purchased. 

So, If I click on a company name in the one table, the second table will show me a list of all the clients who pruchsed that item from that company. 

I want to add a column that shows the count of the clients who purchased the item to my first table. So, Next to the company name, I can see 5 and know that there are 5 different clients who purchsed it. Then, if I click that Company name, the 2nd table will now show me the name of each client and amount purchased. 

Thanks so much!

[Anonymous · Accepted solution]

Hi @waly01,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

In addition, you can also try to use the following formula if it helps:

Client Count =
CALCULATE (
    COUNTROWS ( VALUES ( Table2[Client] ) ),
    FILTER ( Table2, [Cpmpany] = EARLIER ( Table1[Cpmpany] ) )
)

Regards,

Xiaoxin Sheng