Measure for MAX Date, for Every Record

patri0t82 

My apologies. I misunderstood what you were after (I though you only wanted one name based on the last modified date). See if this measure returns what you expect (even in Direct Query?)

Latest Job by date =
VAR _MaxDateTime =
    CALCULATE (
        MAX ( 'Main Table'[ModifiedDate] ),
        FILTER (
            ALLSELECTED ( 'Main Table' ),
            'Main Table'[Name] = MAX ( 'Main Table'[Name] )
        )
    )
RETURN
    CALCULATE (
        MAX ( 'Main Table'[Job] ),
        FILTER ( 'Main Table', 'Main Table'[ModifiedDate] = _MaxDateTime )
    )

patri0t82 

Thinkg about it, I don't think my last suggestion delivers what you need, since it shows the last job by name, but ignores that las modified date. 

So see if this measure returns the job by last modified date:

Latest job by modified date =
VAR _MaxDateTime =
    CALCULATE (
        MAX ( 'Main Table'[ModifiedDate] ),
        FILTER (
            ALLSELECTED ( 'Main Table' ),
            'Main Table'[Job] = MAX ( 'Main Table'[job] )
        )
    )
RETURN
    CALCULATE (
        MAX ( 'Main Table'[Job] ),
        FILTER ( 'Main Table', 'Main Table'[ModifiedDate] = _MaxDateTime )
    )