Calculating by line items and summing up totals

[cocoloco79]

Hi everyone.

I hope I can reach out for help.

I need to sum up line items and calculate a total.

Calculation works If I select one crop and one week at a time, however clearing the filters reults in bad data.

I have attached the pbix and hope someone can help me with this.

Exp. Crop units and Req. crop units dont sum up correctly even though I created a union for crop.

MIN of Commitments.YieldExpected is what I need to use as a multiplier.

https://drive.google.com/file/d/1PEeMTBE4h07KhsHWPIimRpiDuGBAwsir/view?usp=sharing 

[cocoloco79 · Accepted solution]

this was a grouping/relationship issue. I have used a card to visulise the sum by crop rather than planting.

[serpiva64]

I can't have access to your file