Forum Discussion
Remove Duplicate using Dax
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
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])))
2 Replies
Remove the Plant Name column from your Current Outcome, and specify the distance as some sort of aggregation, like minimum, or average.
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])))
