Remove Duplicate using Dax

[py1029]

Hi,

I have a slicer which I can select the plant name. For instance, when I select one of the plant name (Bukit Jalil), it has the following outcome.

When I select another plant name (Ampang Jaya), I got this outcome

When I multi select these two plants (e.g. Bukit Jalil and Ampang Jaya), I got this result.

How do I remove the duplicate Project (Nova Residence) and make it appears once using dax?

Thanks

[V-lianl-msft · Accepted solution]

Please add an index column in query editor then create measure like below and apply it to visual level filter:

Measure = RANKX(ALLSELECTED('Table'[Plant Name]),CALCULATE(MAX('Table'[Index])))

[lbendlin]

Remove the Plant Name column from your Current Outcome, and specify the distance as some sort of aggregation, like minimum, or average.