Hi there.  I think I have this figured out. I used your data.  These are the steps that I took: I used each of the items as a category. I created a new custom item that concatenated the faculty ID and the student ID Fac ID - St ID = Concatenate(Format('FacultyID'n[Raw], 'BEST4.'), Format('Student ID'n[Raw], 'BEST4.')) I created 3 aggregated measures from Fac ID - St ID (you could do this with one) Count = Count [_ByGroup_] ('Fac ID - St ID'n) Distinct = Distinct [_ByGroup_] ('Fac ID - St ID'n) Avg = 'Count'n / 'Distinct'n I was able to create the results you were looking for.   Cheers, Roger ... View more