Find Sales Order that contains Item A,B and C

[KeithChu]

Dear experts,

I would like to find Sales Order that contains Item A, B and C, preferably using a slicer to click instead of hard coding the Item in the expression. Could you give me a starting point to look for?

https://www.daxpatterns.com/basket-analysis/#complete-pattern

I have looked into Basket Analysis and have tried out myself using the AdventureWorks database. I was able to create the measure and graph I needed. However I didn't know what to do when the condition has more than 2 product. 

Any help/direction would be great. Thank you.

[KeithChu · Accepted solution]

ok I found a way to do it. I have to think it as a SQL query.

https://stackoverflow.com/questions/25614699/sql-select-from-header-table-where-detail-table-rows-ha...

SO contain Filter Product = 
IF(
    CALCULATE(
        COUNTROWS('Sales SalesOrderDetail'),
        CALCULATETABLE(SUMMARIZE('Sales SalesOrderDetail', 'Sales SalesOrderDetail'[ProductID]),USERELATIONSHIP('Sales SalesOrderDetail'[ProductID], 'Filter Product'[ProductID]))
    ) = [Selected Filter Product], TRUE, FALSE)

[Floriankx]

If you have only one table with no relations you can just create a measure of all data.

If you slice your data by item or others Power BI can handle this and only the value for the sliced data is shown.