Sum based on Distinct values on another Column

hi,@sgsukumaran

     After my research, you need use ALLEXCEPT Function in your function like below:

Warehouse Processing % = 
DIVIDE (
    CALCULATE (
        SUM ( [Warehouse Processing Offset] ),
        'Orders'[DC Ready To Ship Date] <> BLANK ()
    ),
    CALCULATE (
        DISTINCTCOUNT ( Orders[Pick Ticket Control Number] ),ALLEXCEPT(Orders,Orders[Order Number]),
        'Orders'[DC Ready To Ship Date] <> BLANK ()
    ),
    0
)

Result:

Best Regards,

Lin

hi,@sgsukumaran

      After my test, I didn't notice that there is one slicer "Event year/month" in your report, So please be careful with these 

details when we use ALLEXCEPT Function, try this formula:

Warehouse Processing % = 
DIVIDE (
    CALCULATE (
        SUM ( [Warehouse Processing Offset] ),
        'Orders'[DC Ready To Ship Date] <> BLANK ()
    ),
    CALCULATE (
        DISTINCTCOUNT ( Orders[Pick Ticket Control Number] ),ALLEXCEPT(Orders,Orders[Order Number],Orders[Year Month]),
        'Orders'[DC Ready To Ship Date] <> BLANK ()
    ),
    0
)

Result:

Before

After 

If not your case, please share your complete screenshot of this page, Do mask sensitive data before uploading. 

Best Regards,

Lin

hi, sgsukumaran

        Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Best Regards,

Lin