DAX Last Entry value

[Anonymous]

Hi,

I have below data, I need to return the Name of the last Entry No per JobID and exclude some status.

I have below measure that return the name of the last entry for most jobid but return blank for above one:
Measure=

calculate (max(Tow[To Name]), LASTNONBLANK(Tow[Entry No], max(Tow[To Name])),

    filter(Tow, NOT(Tow[Status] in {0,11,12})

    )

)

Not sure why, can you please help.

Thanks.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, but please try something like below whether it suits your requirement.

New Measure =
VAR _maxentryno =
    MAXX (
        FILTER (
            Tow,
            NOT ( Tow[Status] IN { 0, 11, 12 } )
                && Tow[JobID] = MAX ( Tow[JobID] )
        ),
        Tow[Entry No]
    )
RETURN
    MAXX (
        FILTER ( Tow, Tow[JobID] = MAX ( Tow[JobID] ) && Tow[Entry No] = _maxentryno ),
        Tow[To Name]
    )

[Anonymous]

Thanks, it is working.