DAX Function for 'Customers also bought'

Hi JosephJC

A Basket Analysis pattern will work for this.

http://www.daxpatterns.com/basket-analysis/

Here's a dummy example pbix

First create a 'Filter Product' table with an inactive relationship with your Orders table:

You use the 'Filter Product' table to select the product(s) to be analysed.

Then, assuming you have created your base measures for Quantity/Price etc, you create 'basket analysis' measures with this pattern (taken from DAX Patterns):

Order Quantity for Customers who bought Filter Product = 
CALCULATE (
    [Order Quantity],
    CALCULATETABLE (
        SUMMARIZE ( Orders, Orders[Customer] ),
        ALL ( Orders[Product] ),
        USERELATIONSHIP ( Orders[Product], 'Filter Product'[Filter Product] )
    )
)

This measure will return the Order Quantity for any Products purchased by Customers who purchased the products selected in 'Filter Product'.

Hopefully this or something similar meets your needs.

Cheers,

Owen