Find distinct order count and make some negative

Question

I have a table of sales data where each line is a line item from an order:

I'm trying to get a distinct order count (since there can be multiple lines per order) BUT I want to change the Return orders to a negative number so the end result looks something like this:

Any thoughts how this might be accomplished?

danextian · Accepted Answer

Hi michaelho&nbsp;
&nbsp;
Try this:
Distinct Order Count =
DISTINCTCOUNT ( 'Table'[Order] )
    - CALCULATE (
        DISTINCTCOUNT ( 'Table'[Order] ),
        FILTER ( 'Table', 'Table'[Order Type] = "Returns" )
    )

Forum Discussion

Find distinct order count and make some negative

2 Replies

Related content

IF Negative value

Cannot Distinct Count Negative Values

Average of distinct orders

count distinct

Remove negatives