Forum Discussion
Rank rows by 'unique' id
Hi, decarsul
Based on your description, I modified the table as below.
Table:
You may modified the measure as below. SUM('Table'[WorkorderID]) need to be changed as MAX('Table'[WorkorderID]) because text column can not be used in sum aggregation.
Rank Measure = RANKX( FILTER( ALL('Table'), [CustomerId]=MAX('Table'[CustomerId]) ), CALCULATE(MAX('Table'[WorkorderID])), ,ASC )Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Allan,
Thank you for getting back to me, and explaining the sorting / filtering. That helps a lot in understanding its basic functionality.
I agree that the customer id can be anything, but the workorderid has to be integer right? Because when i change your sample file, remove the integer / number characteristic of the column and add a W infront of the numbers, i nolonger get results.
How would i go about that?
Hi, decarsul
Based on your description, I modified the table as below.
Table:
You may modified the measure as below. SUM('Table'[WorkorderID]) need to be changed as MAX('Table'[WorkorderID]) because text column can not be used in sum aggregation.
Rank Measure =
RANKX(
FILTER(
ALL('Table'),
[CustomerId]=MAX('Table'[CustomerId])
),
CALCULATE(MAX('Table'[WorkorderID])),
,ASC
)
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much for the explenation. i'm using this as the basis of my new report!
I have however added an addition to the if statement in the end, that also if the start date is empty to also show 0.