Total don't fit

[vbourbeau]

Hi, I think it's a common problem but I can't figure it out.

Look the total for my measure "balance" and "total value". It's not the total I'm looking for I try to get the sum...

I know that PowerBi apply the measure to the total value but how can I tel them to do the sum.

I want Balance = 136 , Total Value = 253

source file https://we.tl/t-fm3wYbf9EA

[amitchandak · Accepted solution]

@vbourbeau , row context issue.

Please create both formula's with values or summarize

new balance = sumx(summarize(Table, table[part],"_1",[Balance]),[_1])

or

new balance = sumx(values(table[part]),[Balance])

You can replace [Balance] with actual balance formula

[vbourbeau]

Good 

But what I do with the other column.

the "Total value"