Rank of callid by customer id as a column

[decarsul]

Good day all,

Not all to long ago, i had some help with creating a measure to rank workorders by customer. This measure is as follows:

Rank Measure = 
RANKX(
    FILTER(
       ALL('Table'),
       [CustomerId]=MAX('Table'[CustomerId])
    ),
    CALCULATE(MAX('Table'[WorkorderID])),
    ,ASC
)

Now i want to use the same functionality, but instead of a measure, i want it in a column so that i can actually use the value. And with this, i mean a column in the data model and not in a visual. This so i can check if a customer calls more than once, which option in the voice menu they pick first, 2nd, third, etc.

How would i do that?

[amitchandak · Accepted solution]

@decarsul , the same one as new column

Rank Measure = 
RANKX(
    FILTER(
       ('Table'),
       [CustomerId]=earlier('Table'[CustomerId])
    ),
    'Table'[WorkorderID],
    ,ASC
)

[decarsul]

Sneaky, thats not the same one, that code's been editted. but that works. Thanks!

[decarsul]

If it were only that simple . . . 

When i do that, i get an error message. got to translate it from dutch, but it says something like: 'A circulair dependancy has been detected 'table' rank measure', 'table' rank measure','table' rank measure'