Forum Discussion

TheSweeper's avatar
TheSweeper
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper I
4 years ago

I tried but it didn't work. Thank you though!

 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
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
    Icon for Helper I rankHelper I
    4 years ago

    amitchandak 

     

    Your measure now gives me the correct data just the incorrect total. Truly appreciate your help!!!

     

    Any suggestions on how I can show the correct total? 576+956.72+1,6803.96 = $3,213.68

    I added the new measure below the screenshot. 

    Measure =
    VAR __id = MAX ('Charges'[Charge Line ID])
    VAR __date = CALCULATE ( MAX('Charges'[Charge Last Modified Date] ), ALLSELECTED ('Charges' ), 'Charges'[Charge Line ID] = __id )
    return
    CALCULATE ( Sum ('Charges'[Total Charge] ), VALUES ('Charges'[Charge Line ID] ),'Charges'[Charge Line ID] = __id,'Charges'[Charge Last Modified Date] = __date )
     
    Again, truly appreciate your help!
    Sincerely,
    Amanda Cross