DAX formula to count quantity per sold product on the same orders as the selected product.

[Anonymous]

Hi,

Im trying to write a measure so that i can see all the products that has been sold on the same orders as one or several selected products.

I have a Products table, a Sales table and a copy of Products table, Products (2) that has no relations to the others.

I have tried several formulas that i have found here but all of the result in the exact same thing, is only shows the quantity for the selected product:

measure =

var _orders = summarize(filter(Sales, Sales[product_id] in allselected('Products (2)'[Product ID])), Sales[order_id])

return

calculate(SUM(Sales[Quantity]), filter(Sales, Sales[order_id] in _orders))

[Mahesh0016]

@Anonymous 

Test =
CALCULATE ( SUM ( Sales[Quantity] ), ALLEXCEPT ( Sales, Sales[order_id] ) )

@Anonymous If this post helps, then please consider accepting it as the solution to help other members find it more quickly.THANK YOU!!

[Anonymous]

This measure just sums the quantity for everything that has been sold.

I want to have a measure which i can use in a table to list quantity sold per product but only where these products have been included in an order together with the selected product in the slicer.