Forum Discussion
floarea_pitu
3 years agoFrequent Visitor
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...
- 3 years ago
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.
mangaus1111
3 years agoSolution Sage
Hi floarea_pitu ,
did you try a measure or calculated column?
floarea_pitu
3 years agoFrequent Visitor
Both of them
- mangaus11113 years agoSolution Sage
Can you send a screenshot where I can see the wrong result?