Forum Discussion

stribor45's avatar
stribor45
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

From DAX studio to Power BI DAX code

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 th...
Help
  • stribor45's avatar
    stribor45
    2 years ago

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

    Leason learned 🙂 look at your previous posts 🙂

stribor45's avatar
stribor45
Icon for Post Prodigy rankPost Prodigy
2 years ago

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

Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

hi, stribor45 

use RANK instead of RANKX 

  • stribor45's avatar
    stribor45
    Icon for Post Prodigy rankPost Prodigy
    2 years ago

    Yes i tried that but didnt work for me either. 

     

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