Forum Discussion

bi_analytics's avatar
bi_analytics
Frequent Visitor
4 years ago

SUMX Total Different from Displayed Row Values (Order After Delivery)

Dear Power BI friends.   I'm wondering if you can help me with the following problem. Unfortunately, I cannot share any screenshots because of confidentiality, but I can share the code I used for t...
Need Help
DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
4 years ago

bi_analytics,

 

Try this measure:

 

Order Booked After Delivery = 
SUMX (
    Orders,
    VAR vDeliveryDate = Orders[Delivery Date]
    VAR vRowCount =
        CALCULATE (
            COUNT ( Orders[Order ID] ),
            ALLEXCEPT ( Orders, Orders[Customer ID] ),
            Orders[Delivery Date] > vDeliveryDate
        )
    RETURN
        IF ( NOT ISBLANK ( vRowCount ), 1 )
)