Count Ordernumbers base on duplicate value

Hello Applicable88 

A measure like this should work:

Performance = 
VAR Orders_D = 
    CALCULATETABLE ( 
        VALUES ( Orders[Ordernumber] ),
        Orders[Status] = "D"
    )
VAR Orders_A = 
    CALCULATETABLE ( 
        VALUES ( Orders[Ordernumber] ),
        Orders[Status] = "A"
    )
RETURN
    COUNTROWS ( EXCEPT ( Orders_D, Orders_A ) )

The logic is to take the set of Orders with Status D and remove Orders with Status A using EXCEPT. Any orders with Status A but not Status D will not influence the result.

With your sample data,

• Orders_D = { 1111, 2222, 3333, 4444, 5555 }
• Orders_A = { 1111, 2222, 3333, 7777, 8888 }
• EXCEPT ( Orders_D, Orders_A ) = { 4444, 5555 }

Regards,

Owen