Counting unique values based off another field

[lhudobenko]

In the example attached, I'm trying to count when a "part" has more than one  unique "ID" associated.  So my end results should say:

A  - 2 ( because it has 1 & 5 associated)

B  - 1 (because both IDs are "2"

C - 1 (because both IDs are "3"

It would also be helpful to see what IDs are associated when there is more than 1, but this isnt necessary.

Thank you!

[kaushiknsolanki · Accepted solution]

Hi, Create a table box with Part as dimension and Count(Distinct ID) as Expression(Measure) Hope this helps.