Forum Discussion

sharpedogs's avatar
sharpedogs
Advocate II
6 years ago
Solved

Calculated Row ?

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 on...
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    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's avatar
Anonymous
Not applicable
6 years ago
#DoubleEditionUsers = SUMX(SUMMARIZE('Table', [Primary User], "Qty", DISTINCTCOUNT('Table'[Edition] )), IF([Qty] = 2, 1))