Forum Discussion

Frequent Visitor

5 years ago

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 datase...

Anonymous

Not applicable

5 years ago

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
)