Forum Discussion

gnsantospatty's avatar
gnsantospatty
Frequent Visitor
8 years ago
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 ( Dim...
  • gnsantospatty's avatar
    gnsantospatty
    8 years ago

    I solved, using RELATEDTABLE.
    Formula:
    RANKX(ALL(DimFilial); SUMX(RELATEDTABLE(DimFilial); [Mercantil Valor Líquido]))

gnsantospatty's avatar
gnsantospatty
Frequent Visitor
8 years ago

I solved, using RELATEDTABLE.
Formula:
RANKX(ALL(DimFilial); SUMX(RELATEDTABLE(DimFilial); [Mercantil Valor Líquido]))