Forum Discussion
jordanxie
Helper I
Helper IConstant Dynamic Target Line
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]))
jordanxie Perhaps:
Target Sum = SUMX(ALL('Targets'),[ Somme de 2019 Target ])
1 Reply
- Greg_Deckler
Community Champion
jordanxie Perhaps:
Target Sum = SUMX(ALL('Targets'),[ Somme de 2019 Target ])