topic Problem with Sort Column in DAX Commands and Tips

Problem with Sort Column

Anonymous — Wed, 13 Jul 2022 13:24:16 GMT

Hi,

I´m trying to sort "Level 1" value based on the value in "Primary Key" but I´ve also tried "Primary Key 2" without and success.

Only get this error message: There can´t be more than one value in "Level 1 Order" for the same value in "Level 1".

Regards:

Niclas

amitchandak — Wed, 13 Jul 2022 13:58:13 GMT

Anonymous , I think Primary Key 2 should work. In not Create a new column like this and try to sort on that

if(isblank([Lavel1], blank(), [Primary Key 2])

Use this new column

v-xiaotang — Mon, 18 Jul 2022 10:22:38 GMT

Hi Anonymous

Thanks for reaching out to us.

>>I´m trying to sort "Level 1" value based on the value in "Primary Key" but I´ve also tried "Primary Key 2" without and success.

where are you trying to sort column? in Excel or in Power BI Desktop?

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.