rankx in power bi

[Nobie]

I need help in rankx function.
I want to calculae rankx on product based on sales values but i have 2 more columns added .
i have attached an excel screenshot . Plz help me.
i have attached a link for pbix file with dummy dataset. pbixFile 

[DOLEARY85]

If you want it against every row you can use this:

RANKING = rankx(all('Table'[Product], 'Table'[Product]),calculate( sum([sales]),ALLEXCEPT('Table','Table'[Product])),,desc, dense)

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Nobie]

Hi @DOLEARY85 ,
thanks for the help.
but i didn't get the correct Rank , i have used your solution.
The second table which is highlighted, i want that type of rank.
when i used ur measure against all the columns prodcut,lines,check and sales. It not giving correct result.
can you please help me?

[DOLEARY85]

Hi,

i'm not sure what is different in your version but it seems to work as you pictured for me, i've uploaded the file below for you to look at:

https://drive.google.com/file/d/1lOGn9_WpJUhJJSTVNP6T4WWsl9h9MX3O/view?usp=sharing

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Nobie]

Hi, Thanks  for your response
I am attaching a Power bi pbix 
this contain a pbix file, where i have attached a dummy table data with pbix.

[DOLEARY85]

Hi, 

It looks as though it's working as intended unless you are wanting the rankx function to be dynamic when you select different products in the slicer. if that's the case change the ALL at the begining to ALLSELECTED.

if that's no the issue can you explain what the issue is,

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Nobie]

Hi,

I really want to thanks.

This is working in the dataset that I demo dataset.but in real dataset i am not getting the correct rank.

Can u ping me in my email address . alimdfarukh@gmail.com

So that we can connect for a min?

[DOLEARY85]

Hi, this would work for your summary table, just make sure the sales field is aggregated to sum:

rank =

RANKX (

    CALCULATETABLE (

        VALUES ( 'Table'[Product] ),

        ALLSELECTED ( 'Table'[Product] )

    ),

    CALCULATE ( SUM ( 'Table'[Sales]) )

)

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍