topic Re: Remove Duplicate using Dax in Developer

Remove Duplicate using Dax

py1029 — Fri, 26 Nov 2021 02:16:39 GMT

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

lbendlin — Fri, 26 Nov 2021 16:26:43 GMT

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

V-lianl-msft — Wed, 01 Dec 2021 06:27:05 GMT

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])))