PowerPivot Duplicate Values Help

[Christof]

Hi guys, I am trying to link my BookingsTable to my TradeList by the fields [ABTA] and [BD ABTA], but when i go to link the two, i get this message:


My TradeList definely has no duplicate [BD ABTA] values.

Sample file here:

Top Tours Analysis wip13.xlsm

drive.google.com

Can someone help please?
Any help would be greatly appreciated.
Thanks
Christof

 

[Chihiro]

[BD ABTA] has duplicate values. Use following DAX to check.
Measure:=DISTINCTCOUNT([BD ABTA])=COUNTA([BD ABTA])

If it returns false, then it means there are duplicates.

 

[Christof]

Not sure how to do that.. but I can assure you there are no duplicates in [BD ABTA] on my TradeList table

 

[Chihiro]

I'd recommend looking again.

Following has duplicates.

P577x

P5750

P5816

P5727

P5784

P5801

P5695

P5765

P5712

 

[Christof]

thank you... sorry about this, there were blank spaces at the end of my codes so the remove duplicates thing wasnt working

 

[Chihiro]

No worries, it happens to all of us