Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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)

 

 

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])
No Replies