Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Ranking

Hi there,   This is my very first post here in the community, so I hope I'm doing it in the right way 🙂   I need some help with creating a dax formula for the table "Commodity" , that shows the ...
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
2 years ago

Hi,

Please check the below picture and the attached pbix file.

 

 

 

 

Contract Qty: = 
SUM( sales[Contracted Quantity] )

 

Ranking by physical commodity = 
RANK (
    SKIP,
    ALL ( 'Physical Commodity'[Physical Commodity] ),
    ORDERBY ( [Contract Qty:], DESC )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Jihwan_Kim ,

     

    Thanks for the suggestion, but it does not work 😞

    If I add "Date" to the the table it's messing up with the rank.

     

    Thanks,

    Georgiana