incorrectly calculates the amount per column

[NadiaHap]

Hello! I have a problem -  incorrectly calculates the amount per column. Maybe someone can help me)

I need to calculate  value2 in the table (J2). But due to the incorrect sum of the columns, incorrect values are calculated.

Value 2 =1/SUM(G2:G6)/(1+I2)-1

Date	budget sum	discount 1	discount 2	discount 3	% budget	% budget/ discount 3/discount 1	budget without discount 1
01.11.2022	63 794	-1,34%	-6%	77%	24,47%	0,2429	63 803
01.11.2022	3 645	-1,34%	-6%	77%	1,40%	0,0139	3 646
01.11.2022	57 414	-1,34%	-6%	77%	22,02%	0,2186	57 421
01.11.2022	6 380	-1,34%	-6%	77%	2,45%	0,0243	6 380
01.11.2022	129 454	-1,34%	-6%	77%	49,66%	0,4929	129 471

 I'm stuck on step 5 as I can't get it to count the column sum..
1. budget = SUM('table[budget sum])
2. % budget = budget/CALCULATE([budget],ALLSELECTED('table'[Month])
3. budget without discount 1 = SUMX('table','table'[budget sum]/(1+'table'[discount 1]))
4. Value 1= budget/budget without discount 1
5. % budget/ discount 3/discount 1 = [% budget]/(SUM('table'[discount 3])+1)/(SUM('table'[discount 1])+1) - mistake

I will be grateful for any help!

[Anonymous]

HI @NadiaHap,

It seems like a common measure formula calculate with multiple aggregations, you can take a look at the Greg’s blog about measure total level calculations:

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng