Forum Discussion

YC's avatar
YC
Frequent Visitor
4 years ago
Solved

Help on MAX formula

Hello! I am trying to create a measure or a column to calculate the max value by material and by region, as per below example.  Basically, if I will not filter anything on region, I want to see Max ...
  • tamerj1's avatar
    tamerj1
    4 years ago

    I have updated the formula in the same comment. Please double check and let me know what results you get?

YC's avatar
YC
Frequent Visitor
4 years ago

Hello! Thank you very much for the formula. This is working to show max per material indeed, but if I would filter a certain region, will not give the correct result.

 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

I have updated the formula in the same comment. Please double check and let me know what results you get?

  • YC's avatar
    YC
    Frequent Visitor
    4 years ago

    With second field changed to region worked perfectly fine. Thank you very much for the help!!