Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |