How do i count distinct count from any column when all pending values are 0 and non 0

[gauri]

Hello,

In the screenshot below :

I want to calculate count of complete orders and incomplete orders , which will be calculated as follows :

For count of complete order : 

the product order will be complete when pending product qty is 0 for all the products ( reference is highlighted in green)

For count of incomplete orders :

The product order will be incomplete when pending product qty is either not 0 or is 0 with some qty values for different products with same cust id ( reference is highlighted in yellow)

How do i count these using dax.

Thanks

Gp

[amitchandak · Accepted solution]

@gauri , Create a new column like

if(sumx(filter(table, [cust_id] =earlier([cust_id])),[product_pending_qty])>0,"incomplete", "Complete")

[gauri]

@amitchandak this dax worked after doing few modifications . Thank you