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?

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

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.