Forum Discussion
Solved
Help for Maxx dax function error
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
3 Replies
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 _StreamMaxJanHi,
Thank you very much. Appreciate your help.
Kind Regards,
Thilini
