Calculating remediated vulnerabilities

hi tvm_analyst 

you could try something like this:

new table =
ADDCOLUMNS (
    SUMMARIZE (
        'finding_date',
        'finding_date'[asset_id],
        'finding_date'[vulnerability_id]
    ),
    "firstFoundDate", CALCULATE ( MIN ( 'finding_date'[date] ) ),
    "lastFoundDate", CALCULATE ( Max ( 'finding_date'[date] ) )
)

then, assuming that asset_id and vulnerability_id is unique in the finding-table, create a new column in the new table

isSolvedFlag =
IF (
    ISBLANK (
        LOOKUPVALUE (
            'finding'[date],
            'finding'[asset_id], 'new table'[asset_id],
            'finding'[vulnerability_id], 'new table'[vulnerability_id]
        )
    ),
    1,
    0
)

and then you should be on you way