cancel
Showing results for
Did you mean:
Regular Visitor

## #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

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
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: #5 Dynamic column calculation on Slicer Action Options

It seems that you may select Unpivot Columns in Query Editor first.

https://community.powerbi.com/t5/Desktop/matrix-to-table-help/td-p/329415

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.