Forum Discussion

NPArulventhan's avatar
NPArulventhan
New Member
10 years ago
Solved

Help in DAX

Hi this is my DAX query for Rank
 
Rank = RankX(All(Tablename),"Sum of Sales",,Desc,Dense)
 
Am getting only the top ten value from original,
 
Prob: even i applied a new filter it couldnot reflect in my table.
 
How can i solve this?
Need Help
  • Baskar's avatar
    Baskar
    10 years ago

    Hi Champion,

    Its cool you almost done, but u made a simple mistake.
    Replace the "All" with "Allselected".

    Check it , let me know if not working,
    Power BI Rocks !!!!!

2 Replies

  • Baskar's avatar
    Baskar
    Icon for Resident Rockstar rankResident Rockstar
    10 years ago

    Hi Champion,

    Its cool you almost done, but u made a simple mistake.
    Replace the "All" with "Allselected".

    Check it , let me know if not working,
    Power BI Rocks !!!!!