Forum Discussion

pokarman's avatar
pokarman
Frequent Visitor
6 years ago

How to access measure column inside MIN aur MAX function

Hi All,

 

i want to take max and min value from price column but i use max function its giving same value .

price is a measure

Price = IFERROR(('Value'[Value_])/(QTY[Quantity]),0)
 
 
 
 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    pokarman 

    Measure = MAXX('Value','Value'[Value_])

    Please use below measure to get max value 

    • pokarman's avatar
      pokarman
      Frequent Visitor
      6 years ago

      that is still not working 

       

      I have created measure like 

      Price = 'Value'[Value_]/QTY[Quantity] can i get min value and max value .for price when i select slicer