Forum Discussion

TheSweeper's avatar
TheSweeper
Helper I
4 years ago
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 ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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 )

TheSweeper's avatar
TheSweeper
Helper I
4 years ago

DataInsights 

 

If you have time do you mind taking a stab at this? Unfortunately I can't continue building my report without this formula being completely correct in its output.  😞