Grouping columns from one table to another with DAX

[martijnvanderveldt]

Heyy guys!

I am looking for a formula that can groups volume of a larger table with DAX:

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

To a smaller table

Store 1: Sells 10 Products


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

Thanks for your help!

[p24leclerc]

the pivot table does just that. It is available within DAX.

[martijnvanderveldt]

I know but I don't need to see the values in the table, It is part of a formula to calculate numeric and weighted distribution! So if you would know how to do it within a formula that would be great