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

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

Hi, EMSSS22 

 

You can try the following methods. IF [Miles] is a measure.

Measure = IF(HASONEVALUE('Table'[VehicleNumber]),[Miles],MAXX('Table',[Miles]))

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

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

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

    Thank you for your response - the issue is when I drill back up on the matrix it's still giving me a random number