topic Re: Summarise volume of group in DAX Commands and Tips

Summarise volume of group

Sofiya72 — Wed, 06 Mar 2024 10:30:47 GMT

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.

Re: Summarise volume of group

qqqqqwwwweeerrr — Sat, 22 Jun 2024 06:10:18 GMT

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

Re: Summarise volume of group

Sofiya72 — Wed, 06 Mar 2024 13:51:44 GMT

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.

Re: Summarise volume of group

Dangar332 — Thu, 07 Mar 2024 07:27:52 GMT

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 !!