Forum Discussion
Incorrect Totals: - Matrix
Hi, I have an issue with a measure(s) that I have exhuasted all other resources to solve. I am trying to solve for "Monthly Inflation" which is defined as: ( [Last Unit Cost] - [Base Unit C...
EnrichedUser , Try a measure like this
Sumx(summarize(Table, Table[Order], Table[Line], Table[Eff Date], "_1",( [Last Unit Cost] - [Base Unit Cost] ) * [Average Monthly Usage]), [_1])
if needed add additional column from visual