Forum Discussion

kpangelinan's avatar
kpangelinan
Icon for Helper I rankHelper I
9 years ago
Solved

Calculate SUM and apply a filter

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 ...
Need Help
  • igor's avatar
    igor
    9 years ago

    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's avatar
    v-huizhn-msft
    9 years ago

    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's avatar
igor
Frequent Visitor
9 years ago

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.