calculate the distance between ATM and several other ATM

[Anonymous]

have an ATM database (Gainful of ATM, address, city, city type, longitude, latitude, ID_GAB, ....)

The goal is to remove the maximums  of ATM according to 2 condition:

1-the distance must not exceed 500 meters (example)

2-Find the least profitable ATM to delete it (example)

I found a MEASURE which calculates between 2 distance  😃  

But I do not know how to write a loop that goes from a less profitable ATM and make a comparison with others if it is the most unprofitable we delete it and move on to the 2nd ATM ect ...

THANK YOU ! 

[v-frfei-msft]

Hi @Anonymous ,

We can create two measures as below.

divide = 
CALCULATE (
    DIVIDE ( MAX ( 'Table'[Gainful of ATM] ), MAX ( 'Table'[distance] ) ),
    FILTER ( 'Table', 'Table'[distance] <= 500 )
)

Action = 
IF ( [divide] = MINX ( ALL ( 'Table' ), [divide] ), "ATM REMOVE", BLANK () )

We can create two measures as below to get the excepted result.

divide = 
CALCULATE (
    DIVIDE ( MAX ( 'Table'[Gainful of ATM] ), MAX ( 'Table'[distance] ) ),
    FILTER ( 'Table', 'Table'[distance] <= 500 )
)

Action = 
IF ( [divide] = MINX ( ALL ( 'Table' ), [divide] ), "ATM REMOVE", BLANK () )

[Anonymous]

 @v-frfei-msft  can you help me to make a loop that calculates the distance between an ATM and several other before making the condition on the distances

(adresse1)---(adresse2)

(adresse1)---(adresse3)

(adresse1)---(adresse4)

(adresse1)---(adresse5)

next

(adresse2)---(adresse1)

(adresse2)---(adresse3)

(adresse2)---(adresse4)

(adresse2)---(adresse5)

this is fonction for calculat :

Calcule_distance.pbix