Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Thilini
Frequent Visitor

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])))

 

Thilini_0-1595501545471.png

 

Can anyone help me to get the correct values please.

 

Kind Regards,

Thilini

 

1 ACCEPTED SOLUTION
camargos88
Community Champion
Community Champion

Hi @Thilini ,

 

Try this one:

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

3 REPLIES 3
camargos88
Community Champion
Community Champion

Hi @Thilini ,

 

Try this one:

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Anonymous
Not applicable

@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

Hi,

Thank you very much. Appreciate your help.

 

Kind Regards,

Thilini

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.