Create measure for quota based on values in one column and filter on other column

[Anonymous]

Hi there, 

Basically I have two products (A and B) and I want to create the quota of the sold product A in a specific month:

Sales_of_Product_A / (Sales_of_Product_B + Sales_of_Product_A)

The table is already filtered for the specific month, therefore I will only need to sum the specific sales for the different products and then bring them into the above formula. 

Product	Sales
A	3
B	2
B	1
A	4
B	4
A	3

 --> Output would be: Quota=(3+4+3)/(3+2+1+4+4+3)

Thank you in advance!

[camargos88]

@Anonymous ,

Select the column or measure -> Column Tools -> Format -> Percentage

[camargos88 · Accepted solution]

@Anonymous ,

Try this measure:

_Output = DIVIDE(CALCULATE(SUM('Table'[Sales]), 'Table'[Product ] = "A"), CALCULATE(SUM('Table'[Sales]), ALL('Table'[Product ])))

[Anonymous]

Thanks so much!! This works! Do you know how to convert this to the percentage-format now?