PowerBi_Rankfunction_query

[nknareshkumar21]

Can you please help with below?
This is my table

Below is the function used

Need Help

I am getting 1 for all rows,I need it to show over all rank of the table

Thanks

Naresh

[V-yubandi-msft]

Hi @nknareshkumar21 ,

Has your issue been resolved, or do you require any further information? Your feedback is valuable to us. If the solution was effective, please mark it as 'Accepted Solution' to assist other community members experiencing the same issue.

[V-yubandi-msft]

Hi @nknareshkumar21 ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution we provided for your issue worked for you  or let us know if you need any further assistance?

Your feedback is important to us, Looking forward to your response. 

[V-yubandi-msft]

Hi @nknareshkumar21 ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution we provided for your issue worked for you  or let us know if you need any further assistance?

Your feedback is important to us, Looking forward to your response. 

[V-yubandi-msft · Accepted solution]

Hi @nknareshkumar21 ,

To resolve this, you can use the RANKX  function inside a calculated column instead. This will calculate the rank across the entire table.

1.Go to Modeling > New Column in Power BI Desktop.

Use the following DAX formula:

Rank = 
RANKX(
    ALL('Table (2)'),
    'Table (2)'[Revenue],
    ,
    DESC,
    DENSE
)

2. Replace "Your Table Name" with the actual name of your table.

3. Add this Rank column to your visual alongside Country, Product, and Revenue. 

This will correctly assign a unique overall rank to each row based on Revenue.

Result:

 

If my response solved your query, please mark it as the Accepted solution to help others find it easily.

And if my answer was helpful, I'd really appreciate a 'Kudos'.

[johnt75]

When you calculate the sum you need to force context transition, so that the sum is calculated for the correct combination of country and product

Rank = RANKX( ALL('Table'), CALCULATE( SUM('Table'[Revenue]) ),,DESC, Dense )