look up based on one variable

[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

[Reddyp]

@truptis Please help

[v-jingzhang]

Hi @Reddyp 

Is there any update on this problem? Have you solved it? You can share your solution here to help other users who may have similar problems. 

Best Regards,
Community Support Team _ Jing

[amitchandak]

@Reddyp , Try a measure like

Sumx(Table, if( Table[Location] ="USA" , [Quantity],0) )

[Reddyp]

@amitchandak I am not looking for SUM or SUMX and Both quantity and Location are on different tabels. 
& I dont want true or false
Please check my example 

Quantity(table 1)	Location (table 2)	Desired Result
10	USA	10
30	NZ
22	IND
40	USA	40

[v-jingzhang]

Hi @Reddyp 

Are you displaying Quantity and Location columns from different tables into a table visual currently? If your purpose is to add the third column to the same table visual, you can create a measure with below code

Desired Result =
IF (
    SELECTEDVALUE ( 'Sheet 2'[Location] ) = "USA",
    SELECTEDVALUE ( 'Sheet 1'[Quantity] )
)

If this cannot get what you want, can you show how Sheet 1 and Sheet 2 look like with some dummy data and tell us which columns are for matching? Is there any relationship created between two tables? And you want the result for all matching locations or only for USA? Where did you want to export the result, in a table visual or in a new table?

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.