Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
82 | |
55 | |
39 | |
20 | |
12 |