Good afternoon,
I'm a novice user of PowerPivot, but have used Pivot tables many times. I'm having trouble creating a DAX formula that shows the percent of sales for a list of items that will respond to a row filter (item filter). I get the percentage of total sales for all items, but when I filter on one group within the filter the line amounts don't change.
Here's a copy of the formula in the % of Sales Measure.
How should it be rewritten to allow the filter to work and recalculate on the remaining rows? So it works like the following
Thank you.
JNM
I'm a novice user of PowerPivot, but have used Pivot tables many times. I'm having trouble creating a DAX formula that shows the percent of sales for a list of items that will respond to a row filter (item filter). I get the percentage of total sales for all items, but when I filter on one group within the filter the line amounts don't change.
HTML:
Filter (ALL)
Item Pur Inv Sold % of Sales
1 168 24 145 .013297
2 50 4 46 .004218
3 29 3 25 .002293
4 217 26 183 .016781
Filter 1
Item Pur Inv Sold % of Sales
1 168 24 145 .013297Here's a copy of the formula in the % of Sales Measure.
Code:
[SIZE=1]=(sum('MyTable'[SalesQuantity]))/Calculate(Sum('MyTable'[SalesQuantity]),ALL('MySalesTable'))[/SIZE]How should it be rewritten to allow the filter to work and recalculate on the remaining rows? So it works like the following
HTML:
Filter (ALL)
Item Pur Inv Sold % of Sales
1 168 24 145 .013297
2 50 4 46 .004218
3 29 3 25 .002293
4 217 26 183 .016781
Filter 1
Item Pur Inv Sold % of Sales
1 168 24 145 100.00Thank you.
JNM
