Sales % for Brand and Store

[Beniya_Sam_14]

Hi guys,

The below table is the one am trying to achieve. I have created a measure to find the sales % but I want that in a column so that it help me to create category based on that column.

Measure:  Sales % = SUM('sales'[total_sales])/CALCULATE(SUM('sales'[total_sales]),ALLSELECTED('sales'[BRAND_NAME]))

How can i achieve same values using column?? not measure

Thank you

[marcosvin]

Hello!

To create the categories on numerical values and store them as a column, I believe you need to calculate these percentage values of the total in the transformation step, within PowerQuery, to then create a conditional column saying which percentage each category fits. So when the data is updated, Powerquery will recalculate the results and redefine the ranges. In the following link there is an example of how to do this calculation in PowerQuery: How to calculate Power Query Percent of total or category (exceloffthegrid.com)

Just check if the performance will be satisfactory because it can be a big calculation depending on the number of lines.