DAX to replace duplicate measure values with BLANK

[DW868990]

Hi, 

I have a DAX question I am looking for some advice on - 

I have a simple DAX measure for Total Sales - SUM(Sales[SalesAmount]), in a table with Products like below:

But what I am after is for when the measure returns a duplicate value, for all duplicated values to return BLANK, just wondering how I would need to tweak the measure to get this result. So the end result looks like below. 

Any advice appreciated, thanks in advance. 

[eliasayyy]

hello @DW868990  what do you mean by duplicate value

[DW868990]

As in the above example Bannana, Orange and Lettuce all returned 30, so therefore as that value occurs more than once than they should be BLANK.

[eliasayyy · Accepted solution]

Duplicate Measure = 
VAR CurrentAmount = [Total Amount]
VAR CountOfCurrentAmount = 
    CALCULATE(
        COUNTROWS('table (2)'),
        FILTER(
            ALL('table (2)'), 
            'table (2)'[Amount] = CurrentAmount
        )
    )
RETURN
IF(CountOfCurrentAmount > 1, BLANK(), [Total Amount])

if i helped you solve your question please leave a thumbs up and accept as solution