How to apply max and if condition on multiple column?

Hi RavirajMSE ,

you can try this measure

Measure = 
VAR MaxDate= CALCULATE(MAX('Table'[Date]),ALL('Table'))
VAR MaxShift = CALCULATE(MAX('Table'[Shift]),ALL('Table'))
RETURN
SWITCH(TRUE(),
      SELECTEDVALUE('Table'[Date]) = MaxDate && SELECTEDVALUE('Table'[Shift]) = MaxShift, "Latest Shift",
      "Not the latest Shift"
)

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