Forum Discussion

EMSSS22's avatar
EMSSS22
Icon for Helper I rankHelper I
3 years ago
Solved

MAX Dax

  I am trying to show the MAX value from this column which is made up from a measure The first picture displays a when i drill down I see all the milages but when i drill back up I get a random num...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi EMSSS22 

    please try

    Miles (in selected date range) 2 =
    MAXX ( VALUES ( 'Table'[VehicleNumber] ), [Miles (in selected date range)] )

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi EMSSS22 

 

As far as I understand, you want to get maximum value based on unitnumber, for this you should write a dax code like in the example below.

MAXMiles = CALCULATE(MAX('Table (3)'[Miles]),ALLEXCEPT('Table (3)','Table (3)'[unitNumber]))

 

Since the value you get in the matrix is a numerical value, it will automatically enter the sum operation, so you should choose max instead of sum in the field you are calculating, as I show in the screenshot.

 

 

Best regards,

Ezgi Naz Aslankara

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