SUM / Group by / Total

[Wout]

Hi Forum,

A quick (i think easy) question.

I have to following sales data:

Company | Productname | Quantity | Weight each product | Total weight*

*Measure = SUM (Quantity) * SUM (Weight each product)

The results are:

Company X | Product X | 5000 | 0,50 | 2500

Company X | Product Y | 5000 | 0,25 | 1250

Company Y | Product X | 3000 | 0,50 | 1500

Quantity is not a "custom measure", only summarized.

the value 5000 that is displayed above is the total of Company X, but i want to total of Company X in combination with Product X.

Thanks.

[v-qiuyu-msft · Accepted solution]

Hi @Wout,

Please try this measure:

Measure = CALCULATE(SUM(Table1[Quantity]),ALLEXCEPT(Table1,Table1[Company],'Table1'[Product]))*SUM(Table1[Weight each product])

If it doesn't work, please share some sample data and expected results for our analysis.

Best Regards,
Qiuyun Yu

[Greg_Deckler]

Not sure I can answer that without more information. Can you post sample data in a table? Are the results you posted from a table, a matrix?