topic Customer who bought A not B During Different Time Periods in DAX Commands and Tips

Customer who bought A not B During Different Time Periods

etane — Fri, 27 Jun 2025 19:45:12 GMT

Hello.

I am trying to recreate this chart in PBI:

Trying to count number of customers who has purchased Product A not B, B not A and customers who purchased both A and B during current and previous rolling 12 months.

Please help me construct this. Attached is my work in progress using sample data:

Link

Thanks.

Regarding the WIP file, I've attempted to create measures that allow me to isolate customers who purchased A but not B during a 12 month period. Somehow, it doesn't seem accurate and it doesn't allow me to count the number of customers.

Re: Customer who bought A not B During Different Time Periods

lbendlin — Sat, 28 Jun 2025 01:47:16 GMT

Re: Customer who bought A not B During Different Time Periods

Jihwan_Kim — Sun, 29 Jun 2025 06:29:38 GMT

Hi,

I am not sure if I understood your question correctly, but I tried to recreate the page like below.

Please check the below picture and the attached pbix file.

INTERSECT function (DAX) - DAX | Microsoft Learn

EXCEPT function (DAX) - DAX | Microsoft Learn

Create calculation groups in Power BI - Power BI | Microsoft Learn

Re: Customer who bought A not B During Different Time Periods

etane — Tue, 01 Jul 2025 00:01:11 GMT

lbendlin Thanks! Exactly what I was looking for.

In one of the measures, you typed "A or B" but I am sure you meant "A and B"?

Can you please add a measure that sums up units sold for customers who purchased both A and B?

Re: Customer who bought A not B During Different Time Periods

etane — Mon, 30 Jun 2025 17:24:03 GMT

Jihwan_Kim Thanks! This works well.