Filter the contents inside MATRIX visual

Thor2022 

Actually, thinking about it, the average method could potentially not achieve what you are looking for.

If you have a set of values for a year like {30, 29, 30, 31}, the average method will hide both 30 values.

The following  method however will work: compare the minimum value in a set to the maximum value. If they are the same, all values are the same...

So...

No duplicate profits =
VAR _Min =
    MINX ( ALL ( 'Warehouse table'[Warehouse] ), [Your measure] )
VAR _MAX =
    MAXX ( ALL ( 'Warehouse table'[Warehouse] ), [Your measure] )
RETURN
    IF (
        AND (
            ISINSCOPE ( 'Warehouse table'[Warehouse] ),
            ISINSCOPE ( 'Year Table'[Year] )
        ),
        IF ( _Min = _Max, BLANK (), [Your measure] )
    )

PS. I tried deleting the previous message but the forum won't let me for that particular post for some reason....