Dax compare 2 rows in a calculated column for the same id

[PatrickNahayo]

I have the following table and i need to have the selection for the product with quantity > 2 and in the highest category

a first and c the last

id	category	qty	selection
1	a	2	x
1	b	3
1	c	4
2	a	1
2	b	2	x
2	c	3

[Greg_Deckler · Accepted solution]

@PatrickNahayo Assuming that you mean >= 2 then perhaps this:

Selection Column = 
  VAR __ID = [id]
  VAR __CurrentCategory = [category]
  VAR __Category = MINX( FILTER( 'Table', [id] = __ID && [qty] >= 2 ), [category] )
  VAR __Result = IF( __CurrentCategory = __Category, "x", BLANK() )
RETURN
  __Result