ranking based on multible criteria

[Fahadfx]

HI,
I have a table like this
ID date method

1 6/4/2014 P
1 10/26/2014 P
1 8/27/2014 C
2 7/10/2014 P
2 1/16/2014 C
3 8/12/2014 P
3 4/30/2014 P
3 3/17/2014 C
3 6/4/2014 C
3 8/31/2014 C

I want to rank each ID and method based on date where the result would be like this

ID date method Rank
1 6/4/2014 P 1
1 10/26/2014 P 2
1 8/27/2014 C 1
2 7/10/2014 P 1
2 1/16/2014 C 1
3 8/12/2014 P 2
3 4/30/2014 P 1
3 3/17/2014 C 1
3 6/4/2014 C 2
3 8/31/2014 C 3

I have been able to rank the ID only based on date using this dax
=RANKX(FILTER(ALL(table),table[ID]=EARLIER(table[ID])),table[date],,1)

I hope this is clear for you.
Thanks

 

[scottsen]

I'm not 1000% sure what you want, but I think this is it?

=RANKX (
    FILTER (
        ALL ( TABLE ),
        TABLE[ID] = EARLIER ( TABLE[ID] )  && TABLE[Method] = EARLIER ( TABLE[Method] )
    ),
    TABLE[date],,1
)

Just adding the extra test for Method being the same?

 

[Fahadfx]

Thanks for the help, it did work with me.

Thanks again