Forum Discussion

topazz11's avatar
topazz11
Helper III
4 years ago
Solved

DAX Max value

Hi.

I thought it was easy, but somehow I can't get it to work.

I have a table with 3 value columns.

I want to add another Column which shows the maximum number among the 3 values columns.

Tried a column and measure...it could show each row but doesnt show summary level correctly.

here is the pbix file and screen shot.

Could you help me?

Thanks,

 

PBIX file 

 

Need Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi topazz11 

     

    try this measure:

    Measure_Max Value = 
Var _A = sum('Table'[Value1])
Var _B = sum('Table'[Value2])
var _C = sum('Table'[Value3])
return
max(max(_A,_B),_C)

     

    output:

     

     

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos!!

     

2 Replies

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    Hi topazz11 

     

    try this measure:

    Measure_Max Value = 
Var _A = sum('Table'[Value1])
Var _B = sum('Table'[Value2])
var _C = sum('Table'[Value3])
return
max(max(_A,_B),_C)

     

    output:

     

     

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos!!