A function 'MAXX' has been used in a True/False expression that is used as a table filter expression

[mcam99]

I am trying to return the group for the max value of Consumer Uplift Pre vs Dur.

I had it working with a topn formula but that didnt return a group if the value was negative.

Any ideas?

 CALCULATE
(LASTNONBLANK ( 'Attributes'[SecondaryGroup],1)
,MAXX(KEEPFILTERS(VALUES('Attributes'[PrimaryGroup])),CALCULATE([Consumer Uplift Pre vs Dur])),TRUE())

[Greg_Deckler · Accepted solution]

Yeah, those can get annoying. I think you need something like [Primary Group] = MAXX(...

But, tough to really say with your formula. I reformatted it to this to make it easier to understand. I have no idea what the TRUE() is doing for you.

CALCULATE(
	LASTNONBLANK ( 'Attributes'[SecondaryGroup],1),
	MAXX(
		KEEPFILTERS(
			VALUES('Attributes'[PrimaryGroup])
		),
		CALCULATE([Consumer Uplift Pre vs Dur])
	),
	TRUE())