Constant Dynamic Target Line

[jordanxie]

Hi,

There are 2 tables (Inventory and Target) in this scenario and connected by Plant. There are some plants in Inventory table not present in Target table and vice versa, therefore you see a rise/spike in the green line. The green line represents the current target line which is the sum of target based on plant selection. What would be ideal is to get to the red line where the value (sum of target) would be the same across. 

Current formula:

Target Sum = CALCULATE(SUM(Targets[ Somme de 2019 Target ]),ALL(Targets[Division & Plant]))

[Greg_Deckler · Accepted solution]

@jordanxie Perhaps: 

Target Sum = SUMX(ALL('Targets'),[ Somme de 2019 Target ])