Solved
Amateur Needing Help with Calculated Measure
Can someone kindly help me with this calculated measure? I am trying to get this measure not to exclude Line 2 Charge Amount Totals. The sum for Charge Line ID 8264 should be $576. My measure ...
TheSweeper , Try a measure like
Measure =
VAR __id = MAX ('Table'[Charge Line ID] )
VAR __date = CALCULATE ( MAX('Table'[Charge Last Modified Date] ), ALLSELECTED ('Table' ), 'Table'[Charge Line ID] = __id )
return
CALCULATE ( Sum ('Table'[Total Charge] ), VALUES ('Table'[Charge Line ID] ),'Table'[Charge Line ID] = __id,'Table'[Charge Last Modified Date] = __date )
