Bug: Sort by another Column Error Message

[alwang]

I have a simple table, that contains a "Review Status" column as text, and a conditional column "Status Sort" that is based on the value of "Review Status".  when "Review Status" is null, "Status Sort" is also null.

But when I want to sort "Review Status" by "Status Sort", it shows this message. Power BI is obviously wrong on this. The value dependence between these two columns is absolutely "one-to-one" for sure. Buy Power BI just refuse to acknowlege and recognize this.

The same bug happened with other tables as well. But This issue disappears after I save, closed and reopened the PowerBI file. So it's obviously an Power BI bug that needs to be fixed.

[Anonymous]

Hi @alwang 

According to you, when you saved and reopened it, the error disappeared, so the error only occurs when you perform a sort by? So when you save and reopen it, does your previous action still exist? What version of Desktop are you currently using? Can you provide your table (remove sensitive info) for reference?

Best Regards,
Community Support Team _ Ailsa Tao

[alwang]

hi, thanks for responding.

Sorry I can't share the table since, other than these two columns, all others are sensitive info. But to describe it, it's a table with 100K+ rows, the "Review Status" column has 4 distinct values and nulls {"supported", "acceptable", "materially different","not supported"}. and the "status sort" column has the corresponding value of 1-4 with nulls. These two column are not directly linked to other tables used as keys. And I am using the "Review Status" as legend, and sort it using "status sort".

The error message pop up on the first try (when I initially created the "status sort" column in DAX using "RELATED" function which links to a seperate table where it contains distinct values of "Review Status" and the corresponding value as "status sort"). I am certain that the corresponding value is one-to-one. But the error message keeps showing up. So I changed to calculate the "status sort" column directly within the same table. Same message. So I changed to caclulate the "status sort" column in Power Query, same message. So I saved and closed the file. after re-open the message disappeared. everything else is the same when I closed it.