Counting unique values based off another field

lhudobenko — Sat, 16 Nov 2024 00:47:03 GMT

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!

Re: Counting unique values based off another field

kaushiknsolanki — Fri, 24 Apr 2020 18:29:01 GMT

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