cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SamKamp
Regular Visitor

Rank X Issue

Hello,

 

I've read through many if not all of RankX Posts on here as well as ol' Google and nothing has helped so far.

 

I've removed my Query level filters, so only the visual level filters exist.

 

I've tried the Following Measure versions and some others with the Same Results. I've also tried Using ALLNOBLANKROW and ALL instead of ALLSELECTED.

 

Rank_Client = RANKX(ALLSELECTED('EQ Client Parts Details'[Client No.],'EQ Client Parts Details'[Client Name]),CALCULATE([Total Sell]),[Total Sell],DESC)
 
Rank_Client = RANKX(ALLSELECTED('EQ Client Parts Details'[Client No.],'EQ Client Parts Details'[Client Name]),[Total Sell],[Total Sell],DESC)
 
Rank_Client = RANKX(ALLSELECTED('EQ Client Parts Details'[Client No.],'EQ Client Parts Details'[Client Name]),[Total Sell],[Total Sell],DESC,Dense)
 
Rank_Client = RANKX(ALLSELECTED('EQ Client Parts Details'[Client No.],'EQ Client Parts Details'[Client Name]),[Total Sell],,DESC,Dense)

 

RANKX Issue.PNG

 

FYI - I've tried two version of this as well with no changes to Rank.

 

Total Sell = CALCULATE(SUMX('EQ Client Parts Details','EQ Client Parts Details'[Ext Sell]))
 
Total Sell = SUM('EQ Client Parts Details'[Ext Sell])
0 REPLIES 0

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!