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)] )

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

Hi EMSSS22 

please try

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

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

Thank you this worked!!!!