Forum Discussion
Solved
Rankx Formula is giving duplicates values
Hi I'm new in Power BI and Dax language...
I'm trying to build a revenue-based ranking, but the Rankx Formula is giving me duplicates values. How i can fix this?
Formula:
Rank =
RANKX ( ALL ( DimFilial ) ;[Mercantil Valor Líquido];;;Dense)
I solved, using RELATEDTABLE.
Formula:
RANKX(ALL(DimFilial); SUMX(RELATEDTABLE(DimFilial); [Mercantil Valor Líquido]))
5 Replies
jthomsonSolution Sage
Are the values that RANKX is comparing for those rows the same?
No. they aren't the same
v-chuncz-msftCommunity Support
Share a simplified example if possible. You may also try index column in Query Editor.
I'm using Direct Query.
I solved, using RELATEDTABLE.
Formula:
RANKX(ALL(DimFilial); SUMX(RELATEDTABLE(DimFilial); [Mercantil Valor Líquido]))