How do I remove duplicate values within a specific category of rows

Hi dinosainsburys ,
According to your description, in order to make the final generated data more meaningful, you can try to use the average value, maximum value(Max), minimum value(Min) as a measure for a certain day, and you can do this by modifying the parameter referenced after "Total Value". Here is an example of an average value

Total Value by Date = 
CALCULATETABLE(
    ADDCOLUMNS(
        DISTINCT('Table'[RESULTS.DATE]),
        "Computer",MAX('Table'[Computer]),
        "Total Value", CALCULATE(AVERAGE('Table'[RESULTS.VALUE]),ALLEXCEPT('Table','Table'[RESULTS.DATE]))
    ),
    'Table'[RESULTS.DATE] = 'Table'[RESULTS.DATE]
)

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly