Forum Discussion

jjkmd's avatar
jjkmd
Helper I
7 years ago
Solved

adding up all values in a previous calculation

I'm trying to do a series of calculations that I won't go into at the moment. I'm starting with a column "Charges90Rule" Then create a measure Charges All Partners 90% Rule = CALCULATE(sum(Month...
  • parry2k's avatar
    parry2k
    7 years ago

    jjkmd I don't know how your tables are set up, why you are doing ALL (monthly[provider] and All(Provider)

     

    Looks like you have provider table linked with monthly table.

     

    Try following measure to sum up average

     

    Charges All Partners 90% Rule Capped = 
    CALCULATE( SUMX( VALUES( Monthly[Provider] ), [Average charges per partner 90 Capped]),Monthly[Partner Status]="Partner")
parry2k's avatar
parry2k
Super User
7 years ago

jjkmd I don't know how your tables are set up, why you are doing ALL (monthly[provider] and All(Provider)

 

Looks like you have provider table linked with monthly table.

 

Try following measure to sum up average

 

Charges All Partners 90% Rule Capped = 
CALCULATE( SUMX( VALUES( Monthly[Provider] ), [Average charges per partner 90 Capped]),Monthly[Partner Status]="Partner")
  • jjkmd's avatar
    jjkmd
    Helper I
    7 years ago

    Thanks, that worked with one minor tweak

     

    Charges all partners capped via forums = CALCULATE( SUMX( VALUES( Monthly[Provider] ), [Average charges per partner 90 Capped]),all(Provider),Monthly[Partner Status]="Partner")
     
    That gets me....
     
    You were right I did not need both ALL (monthly[provider]) and All(Provider); but I do need the All(Provider) in order for each row above to be the 3.4M number.  Interestingly the ALL (monthly[provider]) does not get that.
     
    Your formula got me 
     
    Still, that got me on the very right track.  it appears the key was to use the SUMX( VALUES( Monthly[Provider] ).  I"m going to have to research what kind of alchemy that "values" does.  ALso why you used Monthly[provider] with "Values".  I think once I understand that some concepts will click into place.
     
    Thank you parry2k