Forum Discussion
look up based on one variable
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 |
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.