Populate first value based on group

[leandross89]

Hi Dear,

Could you please help me on below Dax logic?

I have a table with 3 collumns Location, device and Topo.

LOCATION	DEVICE	TOPO	Collumn 1
140059	1	2G
140059	2	4G
140059	4	4G
140534	1	4G
140534	3	2G
140534	4	2G
140701	1	2G
140701	2	4G

I wonder how can I do to populate de collumn 1 with the folowing example:

LOCATION	DEVICE	TOPO	Collumn 1
140059	1	2G	1
140059	2	4G	1
140059	4	4G	1
140534	3	2G	3
140534	4	2G	3
140701	1	2G	1
140701	2	4G	1
140703	2	2G	2
140703	3	4G	2

as you can see for each location I need to populate the collumn 1 with the lowest value of collumn device. 

[leandross89 · Accepted solution]

Result = CALCULATE(MIN('Table2'[Device]),ALLEXCEPT(Table2,'Table2'[Location]))
I find the solution, I´m sorry. tks for all