Calculated Row ?

[sharpedogs]

I've got a master list of users with products and some users have multiple products. I need a DAX to calcutale the users who have two editions

I want the DAX to recognize Qty 1, as Chad is the only person to have both Pro and Std

Primary User	Edition
Chad	Pro
Dave	Std
Matt	Pro
Chad	Std
Sam	Pro

[Greg_Deckler · Accepted solution]

Maybe something like:

Measure = 
  VAR __User = MAX('Table'[Primary User])
RETURN
  MAXX(
    FILTER(
      SUMMARIZE(
        ALL('Table'),
        [Primary User],
        "__Count",COUNT([Edition])
      ),
      [Primary User] = __User
    ),
    [__Count]
  )

[Anonymous]

#DoubleEditionUsers = SUMX(SUMMARIZE('Table', [Primary User], "Qty", DISTINCTCOUNT('Table'[Edition] )), IF([Qty] = 2, 1))