Need Calculations

[Jyo27]

Hi Everyone,

Need some help in creating measures/columns . Have Category ,Qty and count columns and based on Category selection filter it should show the ratio column . Ratio is (Count for each Category)/(Total qty for all the selected Categories ). 

Category	Qty	count	Ratio
A	11	1	0.027027
B	11	1	0.027027
C	12	1	0.027027
D	3	2	0.054054
Total	37

If Category 'A' and 'B' is selected on slicer then it should show the output below:

Category	Qty	count	Ratio
A	11	1	0.045455
B	11	1	0.045455
Total	22

[lbendlin]