Duplicates but still not?!?

[Bergh]

Hi. I have a table that contains duplicates. If you look at the big picture, and look at the red marking, it should be the one called MH-054 and not the one called 99. If you then look at the small picture, there are lines that should contain 99, like the green one the selection. There are also 99 in the red marking, but these have different data in the column that the arrow shows. But the green makings in the big picture, I do not understand how to get rid of.

[Anonymous]

Hi @Bergh ,

Sorry for that the information you have provided is not making the problem clear to me.

Do you want to set Conditional formatting for rows? Like——if duplicate rows , then Green, else Red?

Can you please share more details about your expected output to help us clarify your scenario?

Refer to
How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Eyelyn Qin

[Anonymous · Accepted solution]

Are you using a join with the SortMerge algorithm?