Forum Discussion
Totals in Table are incorrect
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...
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
Super User
Super User
Anonymous are you using measure LT Amount. How does your raw data looks like and how does relationship looks like?