topic Calculated Row ? in DAX Commands and Tips

Calculated Row ?

sharpedogs — Wed, 19 Feb 2020 20:53:11 GMT

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

Re: Calculated Row ?

Anonymous — Wed, 19 Feb 2020 21:01:39 GMT

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

Re: Calculated Row ?

Greg_Deckler — Wed, 19 Feb 2020 21:05:37 GMT

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] )