Bottom Sorting with same customer name value

Hi Anonymous ,

Try to modify formula provided by amitchandak for better performance like below:

Current Year top 3 = 
CALCULATE(
    SUMX(
        TOPN(3, ALLSELECTED(DimCustomer[CustomerSk]), [Current Year], ASC),
        [Current Year]
    ),
    REMOVEFILTERS(DimCustomer[CustomerSk])
)

Last Year top 3 based on current = 
CALCULATE(
    SUMX(
        TOPN(3, ALLSELECTED(DimCustomer[CustomerSk]), [Current Year], ASC),
        [Last Year]
    ),
    REMOVEFILTERS(DimCustomer[CustomerSk])
)

If you still encounter memory issues, consider reducing the amount of data being processed or optimizing your data model.

Best Regards,
Adamk Kong

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