cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

## Need help with measure

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

1 ACCEPTED SOLUTION
Helper III

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

4 REPLIES 4
Super User

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.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User

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!

Proud to be a Super User!

Helper III

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

Super User

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!

Proud to be a Super User!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors