List does not contain a reference

[administracion]

Hello, I am trying to get the maximum consecutive order, from a list of consecutive orders (in column: [Consecutivo Sucursal]) by store ([Sucursal]) in a table called 2_Anticipos.

My expression is :  max(select(2_anticipos[Consecutivo Sucursal],[Sucursal]=[_ThisRow].[Sucursal]))

But it tells me that Column Sucursal in expression '[Sucursal].[_ThisRow]' does not contain a reference.

The table is built with orders from all stores, so the consecutive numbers follow the orders of each store and I need to be able to identify the lastest number depending on the store. 

[dbaum · Accepted solution]

---

@administracion wrote:

Column Sucursal in expression '[Sucursal].[_ThisRow]' does not contain a reference

---

This seems to reflect that in the actual app you reversed [_ThisRow].[Sucursal].