Power BI Desktop April 2024 : Sort by issue. False duplicate alert

[dpFr33]

Hi,

I have one calendar table (french).
12 month : Janvier, Février... Décembre 
An integer column [1..12] : 12 values
janvier = 1
février = 2...
etc.

All was working fine and I never had any "duplicate value ..." error message when trying to Sort a column by another one.

Version :  2.128.952.0 64-bit (avril 2024)

Regards,
Denis

[v-yetao1-msft]

HI @dpFr33 

How did you set up the sort? Please provide a screenshot of your setup. 

Best Regards,
Community Support Team _ Ailsa Tao

[IvaD]

I am having the same problem, and it is also new for this month. I have a project table with one column called "Status", and a status order table to sort these status labels in my visuals.

StatusLabelOrderTable

StatusLabel	Order
Yes	1
Maybe	2
No	3
Unreviewed	4

ProjectTable

Project	Status	StatusOrder
ABC	Yes	1
DEF	No	3
HIJ	Unreviewed	4
KL	Maybe	2
NOP	Yes	1

Before, I would add a calculated column StatusOrder = Related(StatusLabelOrderTable[Order]) and sort Status by StatusOrder, but now it says this: 

I filtered by each status label and status order value to confirm there were no cases of anything other than a 1:1 relationship between the status and status order, and there aren't.

Interestingly, I can sort StatusOrder by Status, just not the other way around.