Forum Discussion
Solved
How do i count distinct count from any column when all pending values are 0 and non 0
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 ...
gauri , Create a new column like
if(sumx(filter(table, [cust_id] =earlier([cust_id])),[product_pending_qty])>0,"incomplete", "Complete")
gauri , Create a new column like
if(sumx(filter(table, [cust_id] =earlier([cust_id])),[product_pending_qty])>0,"incomplete", "Complete")
amitchandak this dax worked after doing few modifications . Thank you