number of products by type

[sara_alonso]

Hello,

I am not able to solve a problem from other questions, which I know shouldn't be complicated. I have simplified my example in the following table. 

In the table, each row represents a customer consumption in a store. Customer 1 buys 1 shirt customer 5, 3 jeans. 

Customer	Product	Units	Total units per kind of product	% of number of products by garment, of the total number
1	Shirt	1	6	50%
2	Shirt	3	6	50%
3	Shirt	2	6	50%
4	Jeans	1	4	33%
5	Jeans	3	4	33%
6	Belt	2	2	17%
	Total units	12

My final outcome would be to figure out the last 2 columns in red and especially the last one (which I have now filled up in excel): % of the number of  products grouped by type of garment, relative to the total number of products. More simply, I would like to now how much shirts represent from the total sales. 

For that, I have been trying to count the total number of shirts, jeans, or belts, separately, to compare it to the total number of products sold, but the formulas I am trying are not working. 

Could someone please help me out? 

Many thanks!!

[camargos88 · Accepted solution]

Hi @sara_alonso ,

You need to create 2 measures:

1) 

Measure = CALCULATE(SUM('Tabela (2)'[Units]); ALLEXCEPT('Tabela (2)';'Tabela (2)'[Product]))

2)

% Total = DIVIDE([Measure]; CALCULATE(SUM('Tabela (2)'[Units]); ALL('Tabela (2)')); 0)

I hope it helps you,

Ricardo

[sara_alonso]

That worked perfectly, thanks so much @camargos88 !!