In order to make the Parameter Table work, I created 2 measures in PowerPivot Data Model:
1. Sales Amount:=SUMX(Sales,Sales[Quantity]*Sales[Price])
2. ScaledSalesAmount:=IF(HASONEVALUE(Scale[DivideBy]),DIVIDE([Sales Amount],VALUES(Scale[DivideBy])),[Sales Amount])
When I click on the slicer, nothing happens. Slicer is not shown but it's basically the "ShowValueAs" column of the Slicer table
Excel 2012
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
1. Sales Amount:=SUMX(Sales,Sales[Quantity]*Sales[Price])
2. ScaledSalesAmount:=IF(HASONEVALUE(Scale[DivideBy]),DIVIDE([Sales Amount],VALUES(Scale[DivideBy])),[Sales Amount])
When I click on the slicer, nothing happens. Slicer is not shown but it's basically the "ShowValueAs" column of the Slicer table
Excel 2012
A | B | C | D | E | F | G | H | I | |
---|---|---|---|---|---|---|---|---|---|
1 | Regular Table | PowerPivot Table 1 | PowerPivot Table 2 | ||||||
2 | Product | Quantity | Price | Row Labels | Sales Amount | Row Labels | ScaledSalesAmount | ||
3 | Beverage | 1000 | $5,767.00 | Beverage | 5767000 | Beverage | 5767000 | ||
4 | Snack | 1000 | $2,300.00 | Snack | 2300000 | Snack | 2300000 | ||
5 | Grand Total | 8067000 | Grand Total | 8067000 | |||||
6 | |||||||||
7 | |||||||||
8 | Regular Table for Slicer | ||||||||
9 | ShowValueAs | DivideBy | |||||||
10 | Real Value | 1 | |||||||
11 | Tens | 10 | |||||||
12 | Hundreds | 100 | |||||||
13 | Thousands | 1000 | |||||||
14 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1