Help for Maxx dax function error

[Thilini]

Hi,

I am trying to get Max of fee rate for each stream. I want to get the result as desired max fee highligted in yellow as shown in the table below.

I tried this dax calculation: 

Desired max fee = MAXX(VALUES('Session Budget Tracker'[Stream]),CALCULATE(MAX('Session Budget Tracker'[Session Fee ($)]),ALLEXCEPT('Session Budget Tracker','Session Budget Tracker'[Stream])))

Can anyone help me to get the correct values please.

Kind Regards,

Thilini

[camargos88 · Accepted solution]

Hi @Thilini ,

Try this one:

CALCULATE(MAX(TABLE[FEE]), ALLEXCEPT(TABLE, [STREAM]))

[JustJan]

@Thilini 

Try something like this:

Desired Max Fee = 
var _CurrentStream = SELECTEDVALUE('Table'[Program Stream])
var _StreamMax = 
CALCULATE(
 max('Table'[Fee]),
 ALLEXCEPT('Table','Table'[Program Stream]),
 'Table'[Program Stream] = _CurrentStream
)

return _StreamMax

Jan

[Thilini]

Hi,

Thank you very much. Appreciate your help.

Kind Regards,

Thilini