Forum Discussion
ShaikRafi
5 years agoFrequent Visitor
Ranking issue
Hi All,
I am unable to give the rank, I am getting inconsistent ranking to data
I need ranking based on the deposit amount
I am writing Dax like above based on depositor amount, main dataset (Bets) have other columns also
3 Replies
- Greg_Deckler
Community Champion
ShaikRafi What does your Deposit Amount measure look like? This may help (or not): To *Bleep* with RANKX! - Microsoft Power BI Community
- ShaikRafiFrequent Visitor
Deposit amount is measure
- AnonymousNot applicable
Rank = RANKX( // If you want absulute ranking, // replace ALLSELECTED with ALL. ALLSELECTED( Bets[User Name] ), // Measures do not need to be // wrapped in CALCULATE since the // engine does it automatically // behind the scenes for us. [Deposit Amount],, DESC, DENSE )