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!
Solved! Go to Solution.
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 %
you will have to show me exactly what you are doing otherwise it wont be possible to isolate the problem.
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?
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.