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

Woohooo I figured it out

 

amitchandak Thank you so much for your help!

 

I  used this formula to return the correct total. 

 

SUMX(SUMMARIZE(Charges, Charges[Charge Line ID], "Last Mod Charge", [Measure]), [Last Mod Charge])