Using SELECTEDVALUE but getting no grand total

Thanks Greg_Deckler ! My issue with HASONEVALUE is that there may be multiple accounts with the same parentid so it won't have only one value. It could be that the account with an activation has all of their orders purchased from another location, so I need those to be calculated in this row...but only once in the final. When I was using the calculated column, I created a measure like this:

SUMX(VALUES(Equipment_in_Practice[ParentID]),

    VAR __account = CALCULATE(MAX(Equipment_in_Practice[Product Purchased]),ALLEXCEPT(Equipment_in_Practice,Equipment_in_Practice[ParentID]))

RETURN

__account)

 

Which found the max value only once. But, I'm realizing that isn't right. Because they may activate different accounts at different times which would change the purchase value (see screenshot). Three accounts activated at different times have different totals. It should still be 33859 at the grand total but each line would be different.

 

Does that help clarify at all?