Ranking by year and categories

[Mat87]

Hello

I'm trying to do something that seems very simple but I can't figure a way to do it. 

I have a table that roughly looks like this and I want to create a column that give me the same results as in column E

The calculated column should rank the values in column D by each year for employees within a ceratin supplier. 

Sorry if the explanation wasn't clear but I tried to make it as simple as possible. 

[Mat87]

Here a link to the excel sample 

https://files.fm/f/dwpmqfat

Year	supplier	employee	value	employee rank by supplier
2015	AA	AA1	2	2
2015	AA	AA2	3	1
2015	BB	BB1	5	1
2015	BB	BB2	2	3
2015	BB	BB3	3	2
2016	AA	AA1	2	1
2016	AA	AA2	1	2
2016	BB	BB1	5	1
2016	BB	BB2	3	2
2016	BB	BB3	2	3

[v-jiascu-msft · Accepted solution]

Hi @Mat87,

Try the measure below and download the demo in the attachment, please.

Column =
RANKX (
    ALL ( Table1[employee] ),
    CALCULATE ( SUM ( Table1[value] ), ALL ( Table1[value] ) )
)

Best Regards,
Dale

[Greg_Deckler]

Can you post that sample data as text? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490