Error adding the total of a measure

[Syndicate_Admin]

Nice day

I have a problem when adding the total of a measurement, I have 3 tables realcionasdas OT, OTdetalle, OTEtapas.

The measurements are CostoxStage = SUM(OTDetalle[Cost]) * SUM(OTEtapas[Hec]) / Sum(OT[Hectarea]) The problem is that when filtering for example step 8 the calculation per line is fine but the total does not add up well

Note that the calculation for the total is done by adding the total dl cost 607510,13*1,16/6,64 = StageCost and adding it to give os 318,393,86

I tried the summaize function but I got an error the expression refers to several columns. Multiple columns cannot be converted to a scalar value.

I would appreciate it if you could guide me.

Greetings and of course, very grateful.

[Greg_Deckler]

@Syndicate_Admin First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8