Forum Discussion
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 only person to have both Pro and Std
| Primary User | Edition |
| Chad | Pro |
| Dave | Std |
| Matt | Pro |
| Chad | Std |
| Sam | Pro |
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] )
2 Replies
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] )
