Forum Discussion

EnrichedUser's avatar
EnrichedUser
Icon for Helper III rankHelper III
3 years ago

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...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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