Count Customers who purchased more than X Units - Total not filtered

[etane]

Hello.

This seems to be a very easy DAX but somehow I haven't found the solution.

Here's a copy of a table I am working on:

I just need to count the number of customers who purchased more than 1 unit.  The answer should be 6 in the example above.  But, the total is currently summing all the customers which is 13.  I tried various fashions of sumx and couldn't get anything closer than the if formula.  

Any hints?

Thanks.

[gmsamborn · Accepted solution]

Hi @etane 

Would a measure like this help?

Customers who bought multiple units = 
    COUNTROWS(
        FILTER(
            SUMMARIZE(
                'Table',
                'Table'[Accounts],
                "_Units",
                    SUM( 'Table'[Units Sold] )
            ),
            [_Units] > 1
        )
    )

Let me know if you have any questions.

etane.pbix

(In the model I added DimAccount so I could fix the sort order.)

[etane]

@GS 

Thanks!  Works like a charm.

[Anonymous]

Another option is calculate(distinctcount('Table'[Accounts]), 'Table'[Units Sold] > 1)