Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
@decarsul , the same one as new column
Rank Measure =
RANKX(
FILTER(
('Table'),
[CustomerId]=earlier('Table'[CustomerId])
),
'Table'[WorkorderID],
,ASC
)
@decarsul , the same one as new column
Rank Measure =
RANKX(
FILTER(
('Table'),
[CustomerId]=earlier('Table'[CustomerId])
),
'Table'[WorkorderID],
,ASC
)
Sneaky, thats not the same one, that code's been editted. but that works. Thanks!
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'
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
99 | |
97 | |
73 | |
72 |