Hello -
This is probably an easy one, but I've tried various distinct count, count rows, etc and nothing has worked yet.
I have a Sales Orders table. In that table is the Order # and a new calculated column that identifies the order as either late, or not late, based on a DateDiff formula (from another column). If the due date is yesterday or beyond...then the Order is late (because it has missed its ship date.
I can get a toal count of all rows by using this. But this sums to 108 which is summing up all of the orders (and some orders have multiple lines).
Total Late =
CALCULATE ( COUNTROWS (Operations_Backlog), Operations_Backlog[Late or Not Due Yet] = "Late" )
The value I am looking for should be 64....which is the distinct order count of late orders. (Just a coincidence that it happens to be half of the 108).
I need a formula (measure) that gives me the true total of late orders, based on the unique Order #.
Thanks!
