I want to segment my customers into 4 equal groups

[vrushabjain510]

I have a customers list based on net profits with their Ranks. My requirement is to segment customers into 4 equal groups as follows:

0 - 25% customers in Group Bronze

25 - 50% customers in group Silver

50 - 75% customers in group Gold

75-100% customers in Group Platinum

The grouping of should should be based on Net profit

Thanks in Advance

[v-henryk-mstf · Accepted solution]

Hi @vrushabjain510 ,

There are many ways to achieve this goal. I tried one of them, creating a measure, and judging the conditions satisfied according to the IF function. The specific reference is as follows:

m = 
IF (
    MAX ( 'Table'[Net profit] ) >= 0
        && MAX ( 'Table'[Net profit] ) <= 0.25,
    "Group Bronze",
    IF (
        MAX ( 'Table'[Net profit] ) > 0.25
            && MAX ( 'Table'[Net profit] ) <= 0.5,
        "Silver",
        IF (
            MAX ( 'Table'[Net profit] ) > 0.5
                && MAX ( 'Table'[Net profit] ) <= 0.75,
            "Gold",
            IF (
                MAX ( 'Table'[Net profit] ) > 0.75
                    && MAX ( 'Table'[Net profit] ) <= 1,
                "Platinum",
                BLANK ()
            )
        )
    )
)

Here is the sample pbix file.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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