Forum Discussion
Summing a subtotal
Hello Community - I have two measures. The goal of these measures was to total up Opportunities from our CRM system. Specifically, to segment (and sum up) orders that are orders less than $7...
Anonymous this is I will do
Sum Measure = SUM ( 'Table'[Value] ) Over 75K Measure = SUMX ( VALUES ( 'Table'[Opp] ), IF ( [Measure 2] >= 75000, [Sum Measure] ) )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
parry2k
Super User
Super UserAnonymous this is I will do
Sum Measure = SUM ( 'Table'[Value] )
Over 75K Measure =
SUMX ( VALUES ( 'Table'[Opp] ), IF ( [Measure 2] >= 75000, [Sum Measure] ) )
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!