Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Max Value Error

i want to get Max Value of Measure. I use Maxx Function but the Value which its return it Average Value.  Please Guide How can i get Proper Max Value Using Measure. 
Need Help
jdbuchanan71's avatar
jdbuchanan71
Super User
7 years ago

Instead of using MAXX try MAX([your measure],0).  This will pick the higher of the two scalar values [your measure] and 0.  If your measure can go negative but you still want to pull that if it does you would do MAX([your measure],-9999999)

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi jdbuchanan71

    i create this measure

    Highest Rev/traffic = MAX([MTD RPT],0)

     but still getting incorrect value.

     

    • jdbuchanan71's avatar
      jdbuchanan71
      Super User
      7 years ago

      Hello Anonymous ,

      Can you share the formula in your [MTD RPT] measure?  Given your screen shot, what value are you wanting to see in your measure?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        jdbuchanan71  I USE THIS 

        MTD RPI = TOTALMTD([DBD RPI],Calender[DateKey])
         
        DBD RPI = [DBD SBI GP]/[DBD INVOICE COUNT]
    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      7 years ago

      Hi,

      Try this

      =MAXX(ALL(Calendar),[MTD RPT])

      I am assuming that the Dates appearing in your Calendar visual have been dragged from the Calendar Table.

      Hope this helps.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        HEY Ashish_Mathur  THANKS FOR REPLY

         

        I USE 

        Highest Rev/traffic = MAXX(ALL(Calender[DateKey]),[MTD RPT]) 
         
        RESULT IS 12.47 WHICH IS WRONG. CURRENT VALUE OF WHOLE MONTH IS 22.58