Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
py1029
Frequent Visitor

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.

py1029_0-1637892577966.png

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

py1029_1-1637892635268.png

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

py1029_2-1637892719150.png

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

 

Thanks

1 ACCEPTED SOLUTION
V-lianl-msft
Community Support
Community Support

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

Vlianlmsft_0-1638340010298.png

 

View solution in original post

2 REPLIES 2
V-lianl-msft
Community Support
Community Support

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

Vlianlmsft_0-1638340010298.png

 

lbendlin
Super User
Super User

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.