get data where location criteria matches

[Reddyp]

"quanity" (sheet 1) where "Location" = USA (Sheet 2) = quantity (in new column)

and when location dosent match, the result should be blank 

Quantity	Location	Desired Result
10	USA	10
30	NZ
22	IND
40	USA	40

@Samarth_18
@tamerj1 

[Anonymous · Accepted solution]

Hi @Reddyp ,

I suggest you to try this code to create a calculated column.

Desired Result = IF('Table'[Location] = "USA",'Table'[Quantity],BLANK())

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[technolog]

calccolumn = COUNTROWS( RELATEDTABLE('Sheet 2') )