RANKX by multiple group

HI

i have this table:

i would like to create a measure that dynamically calculate the ranking of each material by total value, but still considering the split by vendor and sub-category so that it would result like this:

I have tried this:

Rank Measure = 

RANKX(allselected('PO Schedule'[Material]),[tot value €],,DESC)