Forum Discussion

KAYKAY181159's avatar
KAYKAY181159
New Member
3 years ago

SUB AND GRAND TOTAL ERRORS

I get wrong sub total and grand total using below formula   =IF(COUNTROWS(FILTER('Order Booking - Improved New',CONTAINSSTRING('Order Booking - Improved New'[Collection],"NOS")))>0.,SUMX('Order Boo...
Need Help
foodd's avatar
foodd
Community Champion
3 years ago

Reformated DAX for the comfort of any reader of this post:

=
IF (
    COUNTROWS (
        FILTER (
            'Order Booking - Improved New',
            CONTAINSSTRING (
                'Order Booking - Improved New'[Collection],
                "NOS"
            )
        )
    ) > 0.,
    SUMX (
        'Order Booking - Improved New',
        ( 'Order Booking - Improved New'[ORD ON HAND] * 0.03 )
    ),
    SUMX (
        'Order Booking - Improved New',
        ( 'Order Booking - Improved New'[ORD ON HAND] * 0.05 )
    )
)