Summarise volume of group

[Sofiya72]

Hi! 
Can someone help me with a measure for Power Query, that will show total volume for  stores, which sell current group of goods? 
 Here is an example of my row data: 

 I count results manually. So I need DAX formula, that can summarise shops volumes for every fruit (but only in that shops where current fruit is selling).
For instance, in jan oranges were selling in shops A and C. So we need to get sum of total volumes in these shops in jan: 2 + 5 + 1 + 7 + 5 = 20. 

Than I plan to use measure in pivot table. 
I am new in Power Query, so sorry if I got mistakes. 

[Dangar332 · Accepted solution]

Hi, @Sofiya72 

try below measure code

result = 
var a = VALUES('Table'[shop])
var b = CALCULATE(
            SUM('Table'[volume]),
            'Table'[shop] in a,
            ALL('Table'[fruit])
        )
return
b

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! 

[qqqqqwwwweeerrr]

Hi @Sofiya72 

I have taken a data format similar to you and this is how you can achieve it, you do not need to create any measure for that you use matrix visual for same.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

Regards

[Sofiya72]

Hi! I see you summarise total volume by SKU, by check my results table: I need to summarise total volume by store, that sell each SKU.