Create a pareto of percent defect per category

[Fair-UL]

Can anyone help with the appropriate DAX to solve this. 

I have this data

project#	defect type	qty
1	a	3
1	b	1
1	c	1
1	a	2
1	a	1
1	a	1
1	b	2
2	a	1
2	b	1
2	b	1
2	b	2
2	c	1
2	a	3
2	c	1
2	a	1
2	c	1

I need to create a stacked bar graph to show percent defect per category a,b,c per each project. I used Dax and it gives me on the stacked bar graph 100% all the time. I am unable to allow it to consider the denimator as the whole number of instances per project 1 or 2. 

I did it in excel for simplification. I used pivot to count #defects per quantity by each defect type and divided over total sum of

a	7
b	3
c	1
a	5
b	4
c	3

this is what i want to graph (i can use stacked bar in pbi)

	project 1	project 2
a	64%	42%
b	27%	33%
c	9%	25%

 I appreciate the help

[amitchandak]

Try like

divide(sum(Table[Qty]),calculate(sum(Table[Qty]),allexcept(Table[defect type])))

[Fair-UL]

I used this same dax before but with Count and ALL, was not correct

now I used yours but I changed the ALLEXCEPT to ALL and it gave me the graph I need. Thank you so much @amitchandak 

[parry2k · Accepted solution]

@Fair-UL here is the measure

% = DIVIDE ( SUM ( 'Table'[qty] ), CALCULATE ( SUM ( 'Table'[qty] ), ALLEXCEPT ( 'Table', 'Table'[project#] ) ) )

here is the output

here is how you do it

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!

[Fair-UL]

Thank you @parry2k I used the same DAX with ALL not ALLEXCEPT as I had multiple layer drilldown in the stacked bar chart and I used all those columns for unfiltering the denominator. Thanks again, the graphs are great!