Create measure % of product sales

[Raul09]

Hi,

I need to acomplish the % marked on RED: 

in this case, is the product % over the total sales of each Rep individually.

This is an example of the Table i'm using

appreciate any help, thanks in advance!

[vanessafvg]

as far as i can tell you need to create 3 measures; 

Sales = sum(amount)

Total Sales = CALCULATE(sum(Table1[amount]), ALL(Table1))

% of Total = CALCULATE(DIVIDE([Sales],[Total Sales] ))

then when you place your categories on a visual it shoud dynamically calcuate the %

[qs]

Hi Vanessa,

Sorry to jump into the middle of your discussion with Raul. I have a similar problem and I thought you might be able to help me. If I use the same table used by Raul, my problem is; How to calculate the percentage of beers over the total number of item's field? In other words, I have to divide  2 over 6 to calculate beer's %, for Vodka 1 over 6, for Coke 1 over 6 etc.
Thanks

Qmars

[Raul09]

I've created all measures as you suggested but is not working properly.

it shows way more than 100%, even using it with out filtering the reps

[vanessafvg]

you will have to show me exactly what you are doing otherwise it wont be possible to isolate the problem.

[Raul09]

i think the problem is this.

in my table i have sales from previous months, so using the measure Total Sales = CALCULATE(sum(Table1[amount]), ALL(Table1)) is actually calculating ALL sales and not using my calendar date filter, am i right?

how can i solve this?

[vanessafvg · Accepted solution]

yes correct change the all to allselected and that should hopefully solve the issue 

[Raul09]

Thanks Vanessa! 🙂