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?

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

Hi YC 
Please try 

 

 

Max price (per material) =
CALCULATE (
    MAX ( 'Dataset'[Price] ),
    ALLEXCEPT ( 'Dataset', 'Dataset'[Material], 'Dataset'[Rgion] )
)

 

 

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!!