topic Re: From DAX studio to Power BI DAX code in DAX Commands and Tips

From DAX studio to Power BI DAX code

stribor45 — Sat, 14 Oct 2023 22:57:51 GMT

My code works fine in Dax Studio but when I move it to Power BI I have some trouble with it. Finally, I was able to change it and make it work but now having trouble with ORDER BY. I want to order the X table by ranking. Can someone help with this please. Also why on some pages it is ORDERBY but somewhere it is ORDER BY.

https://dax.guide/orderby/

https://dax.guide/st/order-by/

MY TABLE = VAR T = SUMMARIZECOLUMNS ( 'TABLEA'[COLUMN1], "REASON", COUNT ( 'TABLEA[COUNT] ) ) VAR X = ADDCOLUMNS ( T, "Ranking", RANKX ( T, [REASON] ) ) RETURN X

Re: From DAX studio to Power BI DAX code

Dangar332 — Sun, 15 Oct 2023 05:43:42 GMT

Hi, stribor45

Use below

MY TABLE =

VAR T =

SUMMARIZECOLUMNS (

'TABLEA'[COLUMN1],

"REASON", COUNT ( 'TABLEA[COUNT] )

)

VAR X = ADDCOLUMNS (

T, "Ranking",

RANKX (

T, [REASON] ,,asc

)

RETURN X

Use Asc or desc as your requirements

And this orderby use in window function like (offset, rank,window)

And this order by use outside of dax query to indicate order of any column or expression.

Re: From DAX studio to Power BI DAX code

stribor45 — Sun, 15 Oct 2023 12:14:38 GMT

The dax code you shared but doesnt order based on REASON or Ranking. I would like this to be ordered by ranking if possible

Re: From DAX studio to Power BI DAX code

Dangar332 — Sun, 15 Oct 2023 13:12:17 GMT

hi, stribor45

use RANK instead of RANKX

Re: From DAX studio to Power BI DAX code

stribor45 — Sun, 15 Oct 2023 23:40:29 GMT

Yes i tried that but didnt work for me either.

VAR X = ADDCOLUMNS(T, "Ranking",RANK (DENSE, T, ORDERBY ([REASON], ASC)))

Re: From DAX studio to Power BI DAX code

stribor45 — Mon, 16 Oct 2023 00:54:45 GMT

I had this same problem while back and posted the question here

Leason learned 🙂 look at your previous posts 🙂