Sample Data

	A	B	C	D	E	F	G	H	I	J	K
1	Division Name	DMA Name	Site Number	Combination Name	Orders	Average Check	Average per Week	Subtotal	Month	Number/Region	<---This column was created using DAX: Number/Region = RELATED('Store Attributes'[Number/Region]), but the slicer is from 'Store Attributes'[Number/Region]
2	DALLAS	KANSAS CITY	9784	MY ORGANIZATION	47	15.59212766	183.2075	732.83	1/1/2018	001KC
3	DALLAS	KANSAS CITY	11123	MY ORGANIZATION	49	12.85836735	157.515	630.06	1/1/2018	001KC
7	RALEIGH	GREENSBORO	3282	MY ORGANIZATION	49	11.38734694	139.495	557.98	1/1/2018	002GREEN
8	RALEIGH	GREENSBORO	8600	MY ORGANIZATION	57	12.38596491	176.5	706	1/1/2018	002GREEN
12	RALEIGH	GREENSBORO	5459	MY ORGANIZATION	64	13.20859375	211.3375	845.35	1/1/2018	002GREEN
13	RALEIGH	GREENSBORO	5537	MY ORGANIZATION	14	13.37285714	46.805	187.22	1/1/2018	002GREEN
14	DENVER	SALT LAKE CITY	7752	MY ORGANIZATION	95	14.39526316	341.8875	1367.55	1/1/2018	003SLC
18	DENVER	SALT LAKE CITY	8539	MY ORGANIZATION	14	14.52714286	50.845	203.38	1/1/2018	003SLC
19	DENVER	SALT LAKE CITY	8540	MY ORGANIZATION	56	14.69839286	205.7775	823.11	1/1/2018	003SLC
20	DENVER	SALT LAKE CITY	5112	MY ORGANIZATION	33	12.48909091	103.035	412.14	1/1/2018	003SLC
21	DENVER	SALT LAKE CITY	8211	MY ORGANIZATION	48	12.69041667	152.285	609.14	1/1/2018	003SLC
22	DENVER	SALT LAKE CITY	9407	MY ORGANIZATION	11	15.64363636	43.02	172.08	1/1/2018	003SLC
23	DENVER	SALT LAKE CITY	3188	MY ORGANIZATION	25	14.1068	88.1675	352.67	1/1/2018	003SLC
24	DENVER	SALT LAKE CITY	3445	MY ORGANIZATION	77	17.0461039	328.1375	1312.55	1/1/2018	003SLC
25	DENVER	SALT LAKE CITY	2993	MY ORGANIZATION	74	13.59040541	251.4225	1005.69	1/1/2018	003SLC
26	DENVER	SALT LAKE CITY	2657	MY ORGANIZATION	54	14.5362963	196.24	784.96	1/1/2018	003SLC
27	DALLAS	KANSAS CITY	2185	MY ORGANIZATION	5	6.91	8.6375	34.55	1/1/2018	003SLC
30	DENVER	SALT LAKE CITY	4710	MY ORGANIZATION	30	12.81666667	96.125	384.5	1/1/2018	003SLC
33	DALLAS	KANSAS CITY	2196	MY ORGANIZATION	6	13.71833333	20.5775	82.31	1/1/2018	003SLC
34	DALLAS	KANSAS CITY	8618	MY ORGANIZATION	7	15.41	26.9675	107.87	1/1/2018	003SLC
35	DALLAS	KANSAS CITY	11227	MY ORGANIZATION	10	11.813	29.5325	118.13	1/1/2018	003SLC
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115