Need Help with Average Total value

[rnagallatav]

Dear All,

Greetings!

I am loading my calculated data from excel into Power BI. After loading, the "totals row" auto-generated by Power BI is summing the average column values as well. I want the average column to display the value as per my calculation logic. If I disable "totals", all the values from that row are disappearing. I want the A and B columns total to be summed and displayed, but the percentage column needs to consider the total sum values of A and B and calculate the overall average as per Formula in percentage header i.e. =[(160/(160+529))*100]

Current Power BI Output
	A	B	Percentage = ((A/(A+B))*100
	9	237	3.66
	5	21	19.23
	14	40	25.93
	112	222	33.53
	16	9	64.00
	4		100.00
Total	160	529	246.35

Expected Output
	A	B	Percentage = ((A/(A+B))*100
	9	237	3.66
	5	21	19.23
	14	40	25.93
	112	222	33.53
	16	9	64.00
	4		100.00
Total	160	529	23.22

Any suggestion would be greatly appreciated.

Thanks in Advance.

[amitchandak · Accepted solution]

@rnagallatav , try like

divide(sum(A),sumx(Table,table[A]+table[B]))

Mark column as % column. Not need to multiply by 100