Top 10%; 10%-20%; 20-50%

[Anonymous]

Hi, 

It should be really easy, but, well.... .

I have column: [Sales Gross]: I need to create column [TABC], where it will:

Calculate the percentage of total sum, and 

• If the sales gross belongs to top 10% of sum, it will return "T"
• If the sales gross belongs to 10% - 20% of sum, it will return "A"
• If the sales gross belongs to 20% - 50% of sum, it will return "B"

Sales Gross
542,45
47,50
576,06
951,13
848,45
405,26
667,73
181,38
259,38
541,16
214,74
58,58
240,99
353,98
65,46
489,49
500,87
20,84
883,75
804,75
918,40
120,83
611,12
735,90
768,23
726,31
241,83

Please advise. 

[Anonymous]

Static segmentation – DAX Patterns

[Jihwan_Kim · Accepted solution]

TABC CC =

VAR _ranking =

RANKX ( Data, Data[Sales Gross],, DESC )

VAR _totalcount =

COUNTROWS ( Data )

VAR _rankpercentage =

DIVIDE ( _ranking, _totalcount )

RETURN

SWITCH (

TRUE (),

_rankpercentage <= 0.1, "T",

_rankpercentage <= 0.2, "A",

_rankpercentage <= 0.5, "B",

"C"

)

Link to the sample pbix file