#6 Help for create data model in Powerpivot for Flat table (fact table)

[_google]

Hi Experts

Looking for suggestion on Data model(PowerPivot) with Fact and dimesion for below Fact table on which i need to measure KPI for "ZONE" with filter option on Area and Region  [ fact Table ( below is example of 60000 R and 90 C) ]

I have create 3 dimension tables 1. Area ( Primary key 60 unique values), Sub Area ( Primary key 130) and ZONE. But struggling to get right combination of relationship

Fillter	Area
Fillter	Sub Area
Zone	QTY
AAA	SUMIFS( QTY, AAA>=0,AAA<=3, Area, Filter Selection, Sub Area, Filter Selection)
BBB	SUMIFS( QTY, DDD>=0,AAA<=3, Area, Filter Selection, Sub Area, Filter Selection)
CCC	SUMIFS( QTY, CCC>=0,AAA<=3, Area, Filter Selection, Sub Area, Filter Selection)
DDD	SUMIFS( QTY, DDD>=0,AAA<=3, Area, Filter Selection, Sub Area, Filter Selection)

Fact table

Type	Area	Sub Area	QTY	AAA	BBB	CCC	DDD
A	FG	V1	10	2	0	2	2
A	FG	V1	0	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	20	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

[v-chuncz-msft · Accepted solution]

@_google,

You may simply use SUMX Function to add a measure.

[_google]

Hi

Do i need to provide any additional information

regards

Kumar