Customer Revenue - Splitting into 10 Quartile

Hi, lwklwk98 

According to your description and sample data, I can roughly understand your requirement, I think you can try this measure to achieve this:

Percent of total =

var _total=SUMX(ALL('Table'),[Profit ($)])

var _profit=CALCULATE(SUM('Table'[Profit ($)]),FILTER(ALL('Table'),[Company]=MAX('Table'[Company])))

return

DIVIDE(_profit,_total)

Then you can change the measure format like this:

Then you can create a clustered column chart to place the fields like this:

And you can get what you want.

You can download my test pbix file below

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

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