Forum Discussion

InsightSeeker's avatar
InsightSeeker
Icon for Helper III rankHelper III
2 years ago
Solved

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 Co...
Need Help
Show and Tell
  • InsightSeeker's avatar
    InsightSeeker
    2 years ago

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

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
2 years ago

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's avatar
    InsightSeeker
    Icon for Helper III rankHelper III
    2 years ago

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

    • rajendraongole1's avatar
      rajendraongole1
      Icon for Super User rankSuper User
      2 years ago

      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!!