Forum Discussion
Calculating Intake value for a product
Hello, can you please help me with the folowing question? How can I calculate the Target Intake? What formula for measure should I use? Thank you!
| Intake | Product | Target | Target Intake |
| January | A | 100 | (Target A+Target B) for January Intake |
| January | B | 100 | (Target A+Target B) for January Intake |
| March | A | 200 | (Target A+Target B) for March Intake |
| March | B | 150 | (Target A+Target B) for March Intake |
Hi, floarea_pitu ;
Try it.
Target Intake = CALCULATE(SUM('Table'[Target]),ALLEXCEPT('Table','Table'[Intake]))the final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Hi floarea_pitu ,
try with this measure
CALCULATE(
SUM('Table'[Target]),
ALL('Table'[Product])
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I just tried, it doesn't work, I obtain the same values as in the target column....
Hi floarea_pitu ,
did you try a measure or calculated column?
Both of them
Can you send a screenshot where I can see the wrong result?
Hi, floarea_pitu ;
Try it.
Target Intake = CALCULATE(SUM('Table'[Target]),ALLEXCEPT('Table','Table'[Intake]))the final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
