Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Solved! Go to Solution.
@jordanxie Perhaps:
Target Sum = SUMX(ALL('Targets'),[ Somme de 2019 Target ])
@jordanxie Perhaps:
Target Sum = SUMX(ALL('Targets'),[ Somme de 2019 Target ])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |