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]))
1 ACCEPTED SOLUTION
@jordanxie Perhaps:
Target Sum = SUMX(ALL('Targets'),[ Somme de 2019 Target ])Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
@jordanxie Perhaps:
Target Sum = SUMX(ALL('Targets'),[ Somme de 2019 Target ])Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Power BI Monthly Update - March 2025
Check out the March 2025 Power BI update to learn about new features.
Fabric Community Update - March 2025
Find out what's new and trending in the Fabric community.
