First occurrence column

HI awitt,

I'd like to suggest you write a measure to add a variable with summarize function to summary records and remove duplicate records based on current 'SintSchoolID', 'Tracking number' groups. Then you can use the iterator function to summary these unique values.

measure =
VAR summary =
    SUMMARIZE (
        ALLSELECTED ( Table ),
        [SintSchoolID],
        [Tracking number],
        "numberofparcels", MIN ( [numberofparcels] )
    )
RETURN
    SUMX ( summary, [numberofparcels] )

If you want a calculated column version, did these any unique field or DateTime values include in your table? If that is the case, you can use them as an index to choose which remains and others to replace with blank.

Notice: the current power bi data mode table does not include column and row index, so you need to use another field that has sortable and unique values as the index.

Regards,

Xiaoxin Sheng