#5 Dynamic column calculation on Slicer Action Options

[_google]

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

[v-chuncz-msft · Accepted solution]

@_google,

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