create tiers 0 <=10K, 10<=20K, 20<=50K Sales

[emveha]

hi 

have a table with gross sales data from -999999 till 99999, now i want to create tiers/categories based on my gross sales as:

0 <=10K, 10<=20K, 20<=50K

so in that case i can see immediately how many customers there are per tier.

Any ideas??

thnx

M

[Anonymous · Accepted solution]

Hi,

load a TierTable with TierCode, TierLabel TierMin e TierMax (es: 1, 0-10K, 0, 10000)

Add a calculated column on your sales table with this formula: 

=CALCULATE(

    VALUES(‘TierTable'[TierCode]),

    FILTER(

        ‘Tier’,

        ‘Tier'[TierMin]<[Gross Sales] &&

        ‘Tier'[TierMax]>=[Gross Sales]

    )

)

Create a relationship between your TierTable and SalesTable using TierCode column in both tables.

For more infos read these posts by Marco Russo:

https://www.daxpatterns.com/static-segmentation/

https://www.daxpatterns.com/dynamic-segmentation/

Regards

Lorenzo

If you like my proposal, please give me a kudos and set my answer as solution.

[amitchandak]

Please refer , if this can help

https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601