RANKX Assigning Same Rank to Different Values

Question

I've been struggling hard with RANKX for a few days now.&nbsp;&nbsp;&nbsp;We are connected to a data model, so we're limited to only measures.&nbsp;I'm trying to create a stack rank that just looks at a revenue total and ranks the entire group highest to lowest.&nbsp;However, it keeps giving folks with similar totals the same rank.&nbsp; It also is skipping values, despite being set to use "Dense" when assigning rank.&nbsp;I've tried troubleshooting it a few different ways, but nothing has worked.&nbsp;Halp!&nbsp; This is easy to do in Excel and I'm really frustrated that it's so difficult in PBI.&nbsp;Here's my Code:&nbsp;_Rank_All_MTD =&nbsp;IF(
    HASONEVALUE(DimBU[OwnerName])
        ,RANKX(
             ALL(DimBU)
            ,CALCULATE([_GM_Total_MTD])
            ,,,Dense
        )
)Here's the Output:&nbsp;

anonymous · Answer

I found a resolution for RANKX assigning a different rank to the same value. I used Round for the [Station Factor] measure to ignore the decimals more than 2 places.

zikopowerbi · Answer

Did you get the solution for this ?

v-lili6-msft · Answer

hi,&nbsp;Anonymous&nbsp;
If there are some filters you have done in the report? what is&nbsp;[_GM_Total_MTD] formula?
Just from a screenshot and rankx formula, we could not find the reason.
If possible share a sample pbix file for us to have a test, or use virtual data to create a sample pbix.
&nbsp;
Best Regards,
Lin
&nbsp;

anonymous · Answer

Hi there,&nbsp;I have excatly the same issuedid you found something ?&nbsp;I really need to fix this !&nbsp;Thanks a lot ^^&nbsp;&nbsp;&nbsp;

anonymous · Answer

I had the same problem. Including Dense at the end of the measure fixed it so it rank sequentially. I think it defaults to skip unless you specify. I'm a Power BI newb, but I hope this helps.Station Factor Rank = RANKX(ALLSELECTED(StationList[STATION]),[Station Factor],,DESC,Dense)&nbsp;I have an issue with RANKX giving the same rank to different values, for instance &nbsp;Value Rank1 - 4 1 - 3 2 - 33 - 24 - 1&nbsp;Not sure how to fix this, but I have been trying to understand it for the last 5 hours. I wish it was easy as excel.&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

RANKX Assigning Same Rank to Different Values

6 Replies

Related content

Assign different value based on other column's value

Assign different value

Best Practices for Assigning Different Workspaces to Different Fabric Capacities

Date Different return wrong value

assigning a different semantic model to a pbi report