Hi
Am looking for help on dynamic report changes (Power Pivot) based on Slice Selection.
Scenario :
Fact data table is Flat mode ( not tabulated/ and cannot restructure) hence in data model had to create table for the ZONE ( Data mode screen)
What is Required,
based on user slicer Selection of "Area" and "Region" the report view to change for Zone for based on criteria
Link of the model https://1drv.ms/x/s!ArfkmPx6DIXHake1H54OkIxmA4A
Through calcuate function
1. =IF([Zone]="AAA",CALCULATE(sum(fTable[QTY]),FILTER('fTable',fTable[AAA]>=0&&fTable[AAA]<=2)),BLANK())
2. =IF([Zone]="BBB",CALCULATE(sum(fTable[QTY]),FILTER('fTable',fTable[BBB]>=0&&fTable[BBB]<=2)),BLANK())
3. Sum area =CALCULATE(sum(fTable[QTY]),'dArea')
| Type | Area | Region | QTY | AAA | BBB | CCC | DDD |
| A | FG | V1 | 10 | 2 | 0 | 2 | 2 |
| A | FG | V1 | 10 | 2 | 0 | 2 | 1 |
| A | FG | V2 | 10 | 0 | 0 | 1 | 1 |
| A | TF | V1 | 10 | 0 | 2 | 2 | 1 |
| A | TF | V1 | 10 | 3 | 1 | 2 | 1 |
| A | TF | V1 | 10 | 2 | 1 | 1 | 2 |
| A | RG | V2 | 10 | 0 | 1 | 1 | 1 |
| A | RG | V1 | 10 | 0 | 2 | 3 | 1 |
| A | RG | V2 | 10 | 2 | 1 | 1 | 1 |
| A | KG | V2 | 10 | 1 | 1 | 1 | 1 |
| A | KG | V2 | 10 | 2 | 2 | 1 | 1 |
| A | KG | V2 | 10 | 1 | 1 | 1 | 1 |
