Forum Discussion
Solved
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 Januar...
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.
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....