total count of member with more than X number of UNIQUE case ID

[konijay]

Member      case ID
jim                 a1
jim                 a1
jim                 a1
jim                 a2
jim                 a3
bob               b1
bob               b1
bob               b2
sam               c1
sam               c2
sam               c3

Hello Experts

I'd like a measure that will show

Total number of members with 3 and up UNIQUE case IDs, in this case = 2 (jim and sam)

thank you

[FreemanZ · Accepted solution]

hi @konijay 

try like:

Measure = 
VAR _table = 
ADDCOLUMNS(
    VALUES(TableName[Member]),
    "Count",
    CALCULATE(DISTINCTCOUNT(TableName[Case ID]))
)
RETURN
COUNTROWS(
    FILTER(_table, [Count]>=3)
)

[konijay]

LOVE U!