Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
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
Hi,
Thank you very much. Appreciate your help.
Kind Regards,
Thilini
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
72 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
126 | |
32 | |
27 | |
24 | |
23 |