topic sort by coloumn in DAX Commands and Tips

sort by coloumn

dlmsbi — Wed, 16 Jun 2021 09:57:35 GMT

Hi All,

I have a question about the next problem:

I am try to sort the rows with different coloumn.The problem is i have same word in the coloumn and two different number in the other coloumn.
Normally i know if i try to sort i'm going to get fault message.
Because is as i know it impossible.

The second coloumn sort by third is no problem.

The problem is the last two coloumn. Because example szint2= X szint2_no= 2 or 1

Somebody know a different way?

Thanks.

Re: sort by coloumn

amitchandak — Wed, 16 Jun 2021 13:04:37 GMT

dlmsbi , You need to have a column with only one value for szint2

create a new column and use that

Sort col = minx(filter(Table, [szint2] = earlier([szint2])),szint2_no)

Re: sort by coloumn

dlmsbi — Wed, 16 Jun 2021 13:06:48 GMT

Thanks I'll try

Re: sort by coloumn

dlmsbi — Wed, 16 Jun 2021 13:40:22 GMT

The result is not bad but not like what i need. (Thanks 🙂)

I need leave alone the [szint2_no] and use the short by coloumn function on [szint2]

For full pictures: The problem starting a path hierarchie and after i get back the names with lookupvalue and i have a coloumn with order_no. There i have 2 and 1. This is the reason why i can't ordering the "Negyedik szint"