Summarize measures

[vipett]

I have a list that looks like this:

Customer	Sales Category A	Sales category B	Total sales	Date
1	200	1000	1200	2021-01-01
1	100	1500	1600	2021-02-01
1	500	1000	1500	2021-03-01
2	200	300	500	2021-01-01

etc

When I aggregate these to a year level, I want to create a "heads up", so if one category falls below 20% of the total sales, I want a 0 to appear, otherwise 1.
So in the output I want to have:

Customer	Sales Score A	Sales Score B
1	0	1
2	1	1

This is because for Category A for customer 1, they only reached 18% of the total sales for 2021.

Doing this with measures is fine and I can create the 0s and 1s, just as they should.

For example Score A = IF(Divide(SUM(SalesA),SUM(SalesB))>0.2,0,1)

BUT, I want to know the total amounts of 1s and 0s, I have understood that there is no way to "summarize" measures, but what options are there available for me to use?

Assuming I have 100 customers and 5 categories, the maximum score I can have is 500, I want to know how many points I scored in one year and compare this to the 500 potential points.

[Anonymous]

"I have understood that there is no way to "summarize" measures"

1. Who told you you can't "summarize" measures?

2. What do you mean by "summarize measures"?

If by "summarize measures" you mean taking a bunch of values of measures and then transforming these values into a value... then it goes without saying that you can do it. Unless your understanding of the phrase "summarize measures" is different than mine.

[vipett]

Sorry, do you want to discuss wordings? Being inexperienced doesn't make it easier to state a question.

Was my actual problem not clear or did you just want to come in and talk about my wordings? In that case I would refer you to Facebook.

But again, I can give my customers a score based on their share of selling in different categories, with measures. And yes, I can add each categories' score together in a measure.

But then I want to add all scores together, to see how many points all my customers have scored, i.e. if the measure says that customer A has scored 2 points, customer B has scored 1 point, customer C has scored 2 points, I want to sum up all the scores to have a total of 5.

If you are able to help me with this, I am very much open for suggestions, or to clarify it further. 

Regarding my wording, please leave that behind.