Measure still displaying lasted scan date

[Anonymous]

We have a weekly scan and I am attempted to display devices NOT in the current scan results (4.20.23, in this case). But the measure still displays 4/20/23. What am I doing wrong?

Fell Off_ = CALCULATE(

    DISTINCTCOUNT('in'[resourceName]),

    KEEPFILTERS(

        'in'[resourceState]

        = "unhealthy"

    ),

    KEEPFILTERS(

        'Tracking'[Last date written]

        > Tracking[Last date written] - 60

    )

)

---------------

Tracking = ADDCOLUMNS(

    SUMMARIZE(

        'in',

        'in'[resourceName]

    ),

    "First found date",CALCULATE(min('in'[exportedTimestamp])),

    "Last date written",CALCULATE(max('in'[exportedTimestamp])))

[Greg_Deckler]

@Anonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Anonymous]

@Greg_Deckler maybe this will help? the following is the output from my measures.

Aging	First found date	Last date written	resourceName	resourceType	controlState	severity
28	3/23/2023 0:00	4/20/2023 0:00	ado-agent-003	virtualmachines	Failed	High
0	4/20/2023 0:00	4/20/2023 0:00	w-perf-test-vm01	virtualmachines	Failed	High
0	4/20/2023 0:00	4/20/2023 0:00	w-perf-test-vm01	virtualmachines	Failed	High

The Excel data this is taken from looks like this

 tabledata 

The first measure First Found Date looks for the first scan date by resourceName (which isn't unique but it's the best we have)

The second measure Last Date Written looks for the last scan date by resourceName

Does that help with the question above?