I have a table with orders and one order has multiple items sold. The order number is unique. some orders are returned next month with minus sales value. I have a calculation for a Distinct count to get the number of orders. My calculation works perfectly for YTD count. but when I bring the month into context it obviously ignores sales returned next month. So monthly volume is not adding up correctly. I want to count orders by removing returned order, Returned orders should be adjusted on current month rather than the month of sales.