topic Re: Help for Maxx dax function error in DAX Commands and Tips

Help for Maxx dax function error

Thilini — Thu, 23 Jul 2020 11:05:20 GMT

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

Re: Help for Maxx dax function error

Anonymous — Thu, 23 Jul 2020 14:56:46 GMT

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

Re: Help for Maxx dax function error

camargos88 — Thu, 23 Jul 2020 15:33:39 GMT

Hi Thilini ,

Try this one:

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

Re: Help for Maxx dax function error

Thilini — Fri, 24 Jul 2020 05:49:53 GMT

Hi,

Thank you very much. Appreciate your help.

Kind Regards,

Thilini