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 )

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