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

Question

&nbsp;Hi Experts&nbsp;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&nbsp; [ fact Table ( below is example of 60000 R and 90 C) ]&nbsp;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&nbsp;&nbsp;FillterAreaFillterSub Area&nbsp;&nbsp;ZoneQTYAAASUMIFS( QTY, AAA&gt;=0,AAA&lt;=3, Area, Filter Selection, Sub Area, Filter Selection)BBBSUMIFS( QTY, DDD&gt;=0,AAA&lt;=3, Area, Filter Selection, Sub Area, Filter Selection)CCCSUMIFS( QTY, CCC&gt;=0,AAA&lt;=3, Area, Filter Selection, Sub Area, Filter Selection)DDDSUMIFS( QTY, DDD&gt;=0,AAA&lt;=3, Area, Filter Selection, Sub Area, Filter Selection)&nbsp;&nbsp;Fact tableTypeAreaSub AreaQTYAAABBBCCCDDDAFGV1102022AFGV102021AFGV2100011ATFV1100221ATFV1103121ATFV1202112ARGV2100111ARGV1100231ARGV2102111

v-chuncz-msft · Accepted Answer

_google,
&nbsp;
You may simply use&nbsp;SUMX Function&nbsp;to add a measure.

Forum Discussion

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

2 Replies

Related content

Create new table

Lakehouse Table Generate Create Table

Create rows from 2 tables

Creating Date Tables

Creating a couple of tables

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)

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