RANKX & ALLSELECTED not returning expected results

[Anonymous]

Hi All,

I am having an issue and hope someone has the insight/expertise to help me resolve this. I am having issues with this particular measure: 

zSequence1ToN = RANKX(ALLSELECTED(Table8[Week Ending]),CALCULATE(MAX(Table8[Week Ending])),,ASC)

It is being used as part of a larger regression calculation, referenced here: Polynomial Regression for Power BI - Noah Severyn (weebly.com).

Per my understanding, this measure should rank the week ending values in ascending order based upon my client filter selection on the dashboard. It works as expected for Client B, however for Client A and Client C it does not work as expected:

For example, for Client A I would like for the first week that client has data (May 23, 2021) to be ranked 1, with subsequent weeks ranked accordingly.

Does anyone have any suggestions or advice on how to rewrite to accomplish this?

[PaulDBrown · Accepted solution]

Try:

zSequence1ToN = RANKX(ALLEXCEPT (Table8, Table8[Client]),CALCULATE(MAX(Table8[Week Ending])),,ASC)