HOW TO CREATE MEASURE OF TOTAL SALES AMOUNT PER REGION, REGION IS IN ANOTHER TABLE

[ahmedkhan]

TOTAL SALES IS A MEASURE WHICH IS IN TABLE 1

REGION IS IN TABLE 2 , table 2 has a relatiohship with table 1 though city

TRYING TO CREATE TOTAL SALES MEASURE ONLY FOR EAST REGION

CITY	Region
A	EAST
B	WEST
C	SOUTH
D	NORTH
E	NORTH
F	EAST
G	WEST
H	SOUTH
I	WEST
J	EAST
K	SOUTH
L	EAST

[serpiva64 · Accepted solution]

Hi,

try this:

EastSales := calculate(sum('Table 1'[Sales]),'Table 2'[Region]="EAST")

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !