RANKx - Dynamic based on Filter Context

Hi v-xicai ,

Thanks for this but it's not doing what I want it to - all the rank values are coming back as 1.

It's the filter context that I'm struggling with so I'm not really following your ALLSELECTED section of the expression. The table itself will split the results by ADVERTISER and FY-Q. But I have 3 other filters I want to use that should dynamically affect the RANK for each ADVERTISERS for each FY-Q. These fields are COMPETITIVE SET, MEDIA MIX and STATE.

Any idea how I incorporate all of these elements into the expression?

Thanks,

MarkJames