Calculating Intake value for a product

[floarea_pitu]

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

[v-yalanwu-msft · Accepted solution]

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]

Hi @floarea_pitu ,

did you try a measure or calculated column?

[floarea_pitu]

Both of them

[mangaus1111]

Can you send a screenshot where I can see the wrong result?

[mangaus1111]

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.

[floarea_pitu]

I just tried, it doesn't work, I obtain the same values as in the target column....