Data Categorisation in a new column

vvibhakar You don't need 3 tables. All you need are 2 calculations.

Sales Per Client = 

CALCULATE(SUM(Table1[Sales]), ALLEXCEPT(Table1,Table1[Client]))

Sales Bucket Per Client = SWITCH(TRUE(),

                                         Sales Per Client >= 10000 && Sales Per Client <25000,"10-25K",

                                         Sales Per Client >= 25001 && Sales Per Client <40000,"26-40K",

                                         Sales Per Client >= 40001 && Sales Per Client <60000,"41-60K",

                                         "60+")

Hi vvibhakar,

You could creata a measure like below.

group =
VAR a =
    SUM ( 'Table'[Sales] )
RETURN
    IF (
        ISBLANK ( a ),
        BLANK (),
        IF (
            AND ( a > 10000, a < 25000 ),
            "10K-25K",
            IF (
                AND ( a > 25000, a < 40000 ),
                "25K-40K",
                IF (
                    AND ( a > 40000, a < 60000 ),
                    "40K-60K",
                    IF (
                        AND ( a > 60000, a < 75000 ),
                        "60K-75K",
                        IF ( AND ( a > 75000, a < 100000 ), "75K-100k", "Above100K" )
                    )
                )
            )
        )
    )

Here is the output.

Hope this can help you!

Best Regards,

Cherry