#5 Dynamic column calculation on Slicer Action Options

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')