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]))
camargos88's avatar
camargos88
Community Champion
6 years ago

Hi Thilini ,

 

Try this one:

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