Sum of Count of distinct occurence for each distinct ID

[eehp]

Hello, I'm struggelling with a problem since more than 16 hours now...
I have 2 table with many to many link  between Name and ArticleCode
Name table look like that

Name	ID
xxx	1234
xxx	2514
bbb	1234
bbb	3569
aaa	1234

ArticleCode table:

ArticleCode	ID
aaaaaaaaaa	1234
ssssssssssss	1234
aaaaaaaaaa	3569
bbbbbbbb	2514

I would like to count the number of unique ArticleCode found for each unique Name and sum it in one measure to be display in a card.
Any ideas how to do it ? I'd try distinctcount, sum, sumx, count and various combination already...

[Greg_Deckler · Accepted solution]

@eehp What's the answer for the supplied data? I get 7 using this:

Measure = SUMX(SUMMARIZE('Table',[Name],"__Count",COUNTROWS(DISTINCT('Table2'[ArticleCode]))),[__Count])

[eehp]

For the supplied data it's 7 yes. I'll check on the whole dataset and valide the answer if correct but it's look promising to me 😄