Product contribution from overall sales

[Anonymous]

Hi,

I have product and Sales and wanted to calculate how much % is occupying by each product from overall sales.

Sum(Sales)/Total(Sales) as example given below.

Product	Sales	Expected output
A	130	6.388206388
B	332	16.31449631
C	321	15.77395577
D	342	16.80589681
E	910	44.71744472

Thanks,

Thimma

[jahida · Accepted solution]

MEASURE = 100 * DIVIDE(SUM('Table'[Sales]), CALCULATE(SUM('Table'[Sales]), ALL('Table'[Product])))

Give that a try.

[v-sihou-msft · Accepted solution]

@Anonymous

Either using calculated column or measure can get expected result. Please refer to formulas below:

Calculated Column:

Column = DIVIDE(Table10[Sales],SUM(Table10[Sales]))*100

Measure:

Pct Of Total = DIVIDE(SUM(Table10[Sales]),CALCULATE(SUM(Table10[Sales]),ALL(Table10[Product])))*100

[123abc]

issue sloved. .... cont.% 

[v-sihou-msft · Accepted solution]

@Anonymous

Either using calculated column or measure can get expected result. Please refer to formulas below:

Calculated Column:

Column = DIVIDE(Table10[Sales],SUM(Table10[Sales]))*100

Measure:

Pct Of Total = DIVIDE(SUM(Table10[Sales]),CALCULATE(SUM(Table10[Sales]),ALL(Table10[Product])))*100

[Habib · Accepted solution]

Power BI has introduced new feature in May release where Power BI clacuate this its own for you. Please refer to below steps.

I have sales measure and being show as stacked chart. Please refer to below image.

Now right click on Sales measure in visual propertise, following menue will be visible and you have option for "Quick Calc"

While clicking on Quck Calc you can see below option for calcuations and you can select % of Grand Total.

This will conver your all measurs to % of your total sales and it will work on all filters as well.

you can see that y axis and tool tip has been changed to new values and each region is having % value as compared to total.

[jahida · Accepted solution]

MEASURE = 100 * DIVIDE(SUM('Table'[Sales]), CALCULATE(SUM('Table'[Sales]), ALL('Table'[Product])))

Give that a try.