Total line of Table, Percentage calculation from sum of columns

[JohnDahis]

Good day!

With this data, I am building a simple table, showing the Total at the bottom.

p.s. the Earn% = (Sell - Buy) / Buy

Name	Buy	Sell	Earn %
John	74	84	13.5%
Kate	50	57	14.0%
Peter	46	73	58.7%

In PowerBI, it gives me a table. the Total Earn% I want it to show 25.9%, which is from (214 - 170) / 170 (instead of a sum of the Earn% column).

How can I do that? Thank you.

[amitchandak]

@JohnDahis ,  Try like

Earn % new = sumx(values(Table[Name]),[Earn %])

In place [Earn %] , you have its calculation

[JohnDahis]

@amitchandakthank you for your reply and adivse.

I folloewed the same, however it doesn't return what's wanted. How can I correct it? Thanks.

[v-xuding-msft · Accepted solution]

Hi @JohnDahis ,

You may try to use a measure. You can find New Measure on the Home Tab.

Click and create a new measure (Earn %) as below:

Earn % = 
var buy = SUM('Table'[Buy])
var sell = SUM('Table'[Sell])
return
DIVIDE(sell - buy,buy)

[JohnDahis]

@v-xuding-msft , that's amazing! thank you!