Calculate SUM and apply a filter

[kpangelinan]

I have a column of Revenue which I would like to calculate the sum for specific products, but do not know how to apply the filter for a product when calculating in a new measure. 

If I can create a measure to calculate the revenue, then I should be able to calculate it against our revenue goal for each Product to see % of respective goals.

Please help. Thanks!

Example Data:

Opportunity Record Type	Revenue
Product A	3689.96
Product B	1590.5
Product C	381.72
Product A	31.81
Product A	2226.7

[igor · Accepted solution]

@kpangelinan  

If the columns are in separate tables, you must relate them to get the expected result.

By doing this you simply add them into a table view that the total of each product will appear instantly.

[v-huizhn-msft · Accepted solution]

Hi @kpangelinan,

In your resource table, the revenue is located another table? If it is, please create a relationship between the two tables. Then create a calculated column like the formula below.

revenue=SUM(RELATED(Table2[revenue]))

For your given table, there are different revenue values for same product? For instance, ProductA have 3689.96, 31.81 and 2226.7, which is unintelligible. Please share details, so I can analyze deeply.

Best Regards,
Angelia

[igor · Accepted solution]

@kpangelinan  

If the columns are in separate tables, you must relate them to get the expected result.

By doing this you simply add them into a table view that the total of each product will appear instantly.