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 $75,000 and to sum up orders that were equal to or greater than $75,000.
However, the numbers being added up are not correct. Here is an example of what my output should be:
Opportunity Name Opportunity Value
ABC $125,000
DEF $100,000
GHI $50,000
JKL $80,000
MNO $25,000
If I put these on a card visual, the 2nd measure (greater than 75k) should show a total of $305,000. The first measure should show $75,000. Again, the goal is to sum up the total values depending on their segmentation: => 75k or < 75k
The "description" used in the measure formula, is the unique identifier of the opportunity.
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!
1 Reply
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!