When values duplicate then green when unique then Red

hi Iam_Syed ,

Not sure if i fully get you, supposing you have a data table like:

try to plot your expected matrix visual and apply conditional formatting for the value field background based field value with a measure like below:

Measure = 
VAR _cat = MAX(data[category])
VAR _type = MAX(data[type])
VAR _table =
    ADDCOLUMNS(
        SUMMARIZE(
            FILTER(
                ALL(data),
                data[category] = _cat && data[type] <> _type
            ),
        data[category], data[type]
        ),
        "Amt",
        CALCULATE(SUM(data[sales]))
    )
VAR _AmtList = SUMMARIZE(_table, [Amt])
VAR _result = IF([SalesAmt] IN _AmtList, "Green", "Red")
RETURN _result

it works like:

hello Iam_Syed 

for subtotal, just tick either column or row subtotal or both depend on your need.

Thank you.