Each Customer Total Rollup

Hi,

You may download my PBI file from here.

Hope this helps.

Hi sneevand ,

You can use the following measure for instead:

Measure =
SUMX (
    SUMMARIZE (
        'Table',
        'Table'[CustomerNo],
        'Table'[YearValue],
        "Total Qty",
            IF (
                CALCULATE (
                    SUM ( 'Table'[Qty] ),
                    FILTER (
                        ALLEXCEPT ( 'Table', 'Table'[CustomerNo] ),
                        'Table'[YearValue]
                            = MAX ( 'Table'[YearValue] ) - 1
                    )
                ) = 0,
                0,
                CALCULATE (
                    SUM ( 'Table'[Qty] ),
                    FILTER (
                        ALLEXCEPT ( 'Table', 'Table'[CustomerNo] ),
                        'Table'[YearValue] = MAX ( 'Table'[YearValue] )
                    )
                )
            )
    ),
    [Total Qty]
)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai