Forum Discussion

Thilini's avatar
Thilini
Frequent Visitor
6 years ago
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 ...
DAX Calculation
DAX function
dax measure
POWER BI Dax rules
  • camargos88's avatar
    camargos88
    6 years ago

    Hi Thilini ,

     

    Try this one:

    CALCULATE(MAX(TABLE[FEE]), ALLEXCEPT(TABLE, [STREAM]))
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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
  • Thilini's avatar
    Thilini
    Frequent Visitor
    6 years ago

    Hi,

    Thank you very much. Appreciate your help.

     

    Kind Regards,

    Thilini