Need help with measure

[InsightSeeker]

Hello - I need help to create a measure as described below:

If the 'Table 1 Supplier' is equal to the 'Table 1 Supplier', return the supplier code from 'Table 1'.

Table 1
Supplier Code	Supplier
123	Fruit
126	Vegetables
129	Spare Parts
132	Tyres

Table 2
Inv No	Supplier	Result (Supplier Code)
233131	Fruit	123
256363	Vegetables	126
279595	Spare Parts	129
302827	Tyres	132
326059	Fruit	123
349291	Vegetables	126
372523	Spare Parts	129
395755	Tyres	132
418987	Fruit	123
442219	Vegetables	126
465451	Spare Parts	129
488683	Tyres	132

Thanks

[Ashish_Mathur]

Hi,

Create a relationship (Many to One and Single) from Table 2 to Table1.  To your visual, drag Supplier from Table 1.  Write this measure

SC = max('Table1'[Supplier code])

Hope this helps.

[rajendraongole1]

Hi @InsightSeeker -Create a new column in table 2 uses LOOKUPVALUE to search 'Table 1' for the matching 'Supplier' and returns the corresponding 'Supplier Code'.

calculated column:

Result1 (Supplier Code) =

LOOKUPVALUE(

    'SP1'[Supplier Code],

    'SP1'[Supplier], 'Sp2'[Supplier]

)

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[InsightSeeker · Accepted solution]

Hi @rajendraongole1  - I want to acheive this thorugh measure instead of calculated column, is it possible?

[rajendraongole1]

Hi @InsightSeeker - Creating a measure to replicate the functionality of LOOKUPVALUE can be challenging because measures in Power BI are context-sensitive calculations meant to aggregate data rather than perform row-by-row operations.

you have to mark mine reply as a solution. 

Can you do it?

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!