DAX Group and SUM from one table to another

M

martijnvanderveldt

New Member
Joined
Sep 10, 2014
Messages
13
Hi Guys!

I am looking for a formula that groups the volume values of a larger table with dax:

Outlet 1: Sells 3 of product A
Outlet 1: Sells 4 of Product B
Outlet 1: Sells 3 of Product C

To a smaller table

Outlet 1: Sells 10 Products


Lookupvalue doesn't work since the second table expects single values and not multiples.

Would be of great help, thanks guys :D!
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
You must log in or register to reply here.

Similar threads

L
  • Solved
DAX: Double or Nested COUNTX() & SUMX()
Replies
6
Views
532
luuk
L
K
  • Solved
DAX median in pivot table for an "almost empty" column
Replies
1
Views
216
Katchi
K
I
  • Solved
DAX measure that filters a table to a single row and returns text from a specified column (Excel365)
Replies
3
Views
295
Insert_Key
I
P
  • Question Question
DAX PIVOT: Projects Closure Date Field - Number of Days Change - between differing Forecast Versions
Replies
0
Views
398
phil134
P
RICH937
  • Question Question
How to create Running Totals on multiple non-date values and conduct filtered analysis on the results. Which Power Tool is the more efficient choice?
Replies
3
Views
445
RICH937
RICH937

Forum statistics

Threads
1,224,122
Messages
6,176,502
Members
452,733
Latest member
Gao87

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top