I hope you guys can help me out. 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 seem to work since the second table expects single values and not multiples.