Totals in Table are incorrect

[Anonymous]

The values in the table below are accurate but the totals for "LT Amount"(from a related table) and "Variance" are incorrect. How do i fix this
LT Amounts total should equal -17952.5
Variance total should equal -5380

[v-eachen-msft]

Hi @Anonymous ,

You could refer to this case which is similar to yours.

https://community.powerbi.com/t5/Desktop/Same-amount-of-Total-line/td-p/860579

You could share your data here for further support if possible.

[Anonymous]

I solved the issue. I had to build a calculated colum to give me the most recent CreatedOn values and then write a sumx function that references that RecentCreatedOn Calculated Column.
Thank you very much for help and the useful link, that helped with another report i had.

[v-eachen-msft]

Hi @Anonymous ,

You could accept any reply you like if your issue has been solved.

This can help the other members find it more quickly.

[Anonymous · Accepted solution]

Create a Calculated Column : "RecentCreatedOn" = Calculate(Max(Table[Date]), Filter(Table, Table[Key] = Earlier(Table[Key]))

then create a measure for the"MostRecentFactAmount" = Sumx(Filter(Table, Table[Date] = Table[RecentCreatedOn]), Table[Amount]).

[parry2k]

@Anonymous are you using measure LT Amount. How does your raw data looks like and how does relationship looks like?