Count Row with Multiple Criteria

[FruitBat]

Having difficulty counting the number of users with multiple group assignments.  Data look like that found in the table below.  Solution I seek is "1", indicating that there's a count of only one user - John - who's assigned to multiple groups (A, B, C).  In this instance, I don't want to count Ted and Bill; they're only assigned to one group.

Kind thanks!

Name

Name	Group
John	Group A
John	Group B
John	Group C
Ted	Group A
Bill	Group A

[Anonymous]

Hi, @FruitBat 

You can first create a column to check whether the names match your conditions, then create a measure to distinct count ‘True’

matched column = IF(CALCULATE(DISTINCTCOUNT('Table'[Group]), 
                      ALLEXCEPT('Table', 'Table'[Name])) > 1, TRUE(), FALSE())

count measure = CALCULATE(DISTINCTCOUNT('Table'[Column]), 'Table'[Column] = TRUE())

Paul
Best
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

@FruitBat Please create following measure to get count of name associated with more then one group

Measure = 
VAR _groupCount = CALCULATE(COUNTX('Table','Table'[Group]),ALLEXCEPT('Table','Table'[Name]))
VAR _table = SUMMARIZE('Table','Table'[Name],"GroupCount",CALCULATE(COUNTX('Table','Table'[Group]),ALLEXCEPT('Table','Table'[Name])))
RETURN SUMX(FILTER(_table,[GroupCount]>1),[GroupCount])

[FruitBat]

Nailed it.  Thanks, @Anonymous !