PowerBI DAX Filter against another table

[gavs73]

Hi

Would appreciate any help with this, I have two tables, one of Sales and one of VIP Customers, the sales table will include customers not in the VIP Customer table.

I want to create a Measure to find a distinct count of VIP Customers in the Sales table who have bought a sale and a non sale product.

I’ve been trying to filter the Sales Table on the VIP Customer table, to get sales only relating to VIPs and then Distinct Counting those but I’ve had no success.

Thanks for any help.

Gav



VIPSales =

CALCULATE(

DISTINCTCOUNT(

Sales[USERID]),

Sales[SaleItem]=1|| Sales[SaleItem]=0 -- This filters on VIPs who have had a sale and non sale purchase in the month

CROSSFILTER(Sales{UserID],VIPS[UserID],OneWay_LeftFiltersRight)

)