Forum Discussion
look up based on one variable
"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 |
5 Replies
Reddyp , Try a measure like
Sumx(Table, if( Table[Location] ="USA" , [Quantity],0) )
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 exampleQuantity(table 1) Location (table 2) Desired Result 10 USA 10 30 NZ 22 IND 40 USA 40 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.
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
