Dax measure to count and filter

[GJA]

Hi, 

I'am looking for a DAX measure (not a column) which can calculate the number of people who have 2 or more purchases. In this example the result should be 2. It looks pretty easy but I can't find the solution. Thx for your help.

People	Purchase
P1	Pu1
P1	Pu2
P1	Pu3
P2	Pu4
P3	Pu5
P4	Pu6
P4	Pu7

[MattAllington · Accepted solution]

It depends on your table structure. Assuming you have a single table called Table, this would work

=sumx(all(Table[People]),if(CALCULATE(countrows(table))>1,1))

[GJA]

Hi Matt, 

thank you it works well