Forum Discussion

ian11001's avatar
ian11001
Frequent Visitor
3 years ago
Solved

How to get the Second & Third Maximum Value

Hello Good Day, I have multiple measures, I already able to get the maximum value using this command below in DAX Measure. Max Value =  Var list = { [Measure1],[Measure2],[Measure3],[Measure4],[...
Need Help
Show and Tell
Tips and Tricks
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    plse try this

    Max 2 Value  = 
Var list = TOPN(2,{ [Measure1],[Measure2],[Measure3],[Measure4],[Measure5]},[Value],DESC)
Return
MINX(list,[Value])

Max 3 Value  = 
Var list = TOPN(3,{ [Measure1],[Measure2],[Measure3],[Measure4],[Measure5]},[Value],DESC)
Return
MINX(list,[Value])
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

plse try this

Max 2 Value  = 
Var list = TOPN(2,{ [Measure1],[Measure2],[Measure3],[Measure4],[Measure5]},[Value],DESC)
Return
MINX(list,[Value])

Max 3 Value  = 
Var list = TOPN(3,{ [Measure1],[Measure2],[Measure3],[Measure4],[Measure5]},[Value],DESC)
Return
MINX(list,[Value])