Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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 !!
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 !!
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: https://www.youtube.com/@letssolveproblem
Regards
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.
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
82 | |
55 | |
39 | |
20 | |
12 |