Tableau: Distinct count of a field which occurs more than once

Question

I have a field customer_id and I need to track the number of unique users and repeat users. For example the table is as below:

customer_id
11
22
33
11
44
22

Answer 1

According to your filter needs, you can rely on LOD using FIXED/INCLUDE:

{ FIXED [Customer Id] : if sum({ FIXED [Customer Id] : COUNT([Customer Id])}) > 1 then 1 end }

Basically, in the inner LOD you count the occourrences, and then you just take in consideration records having 2+ (>1) of them: