Customer who bought A not B During Different Time Periods

[etane]

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.  

[lbendlin · Accepted solution]

[Jihwan_Kim · Accepted solution]

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

[etane]

@Jihwan_Kim   Thanks!  This works well.

[lbendlin · Accepted solution]

[etane]

@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?