Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

View all the Fabric Data Days sessions on demand. View schedule

Reply
NPArulventhan
New Member

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?
1 ACCEPTED SOLUTION
Baskar
Resident Rockstar
Resident Rockstar

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 !!!!!

View solution in original post

2 REPLIES 2
Baskar
Resident Rockstar
Resident Rockstar

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 !!!!!

hai baskar,

           Thanks,I got an output as i expect..

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors