measure to return Latest value for each employee

[PompanoPete]

I have a fact table with events, a date table, and a person table.  I am trying to write a measure that returns the most recent event for each employee.  Having trouble, any help appreciated.  Below is what I have started..

_most recent Event =

CALCULATE (

    MAX ( vFactEmployeeEvent[Event Name] ),

    FILTER (

        ALL ( vFactEmployeeEvent ),

        'Date'[Full Date] = MAX ( 'Date'[Full Date] ),

        'Person'[Employee Number] = 'Person'[Employee Number]

    )

)

[FreemanZ]

hi @PompanoPete ,

try to plot a table visual with 'Person'[Employee Number] column, 'Date'[Full Date]  column and a measure like:

_most recent Event =

CALCULATE (

    MAX ( vFactEmployeeEvent[Event Name] ),

    FILTER (

        ALL ( vFactEmployeeEvent ),

        'Date'[Full Date] <= MAX ( 'Date'[Full Date] )&& 'Person'[Employee Number] = MAX('Person'[Employee Number])

    )

)

[Dangar332]

Hi, @PompanoPete 

try below

_most recent Event =
var a = calculate(max('Date'[Full Date]),allexcept('Person','Person'[Employee Number]))
CALCULATE (
    MAX ( vFactEmployeeEvent[Event Name] ),
    FILTER (
        ALL ( vFactEmployeeEvent ),
        'Date'[Full Date] = a,
        'Person'[Employee Number] = 'Person'[Employee Number]
    )
)

[PompanoPete]

I added a return before calculate.  Here is the latest.

getting error stating cannot find ful Date..  I seem to get this allot and tried using related but no luck.

I tried returning just the variable a, which evaluated without error, but instead of getting the max date, I just got full date and the number of rows for Employee1 jumped from 11 to hundreds.  I suspect one for each row in the fact table.  Thanks for the response.  Below is sample data.

[Dangar332]

_most recent Event =
var a = calculate(max('Date'[Full Date]),allexcept('Person','Person'[Employee Number]))
CALCULATE (
    MAX ( vFactEmployeeEvent[Event Name] ),
    FILTER (
        ALL ( vFactEmployeeEvent ),
        'Date'[Full Date] = a &&
        'Person'[Employee Number] = 'Person'[Employee Number]
    )
)

Hi, @PompanoPete 

replace ( , ) with &&