Forum Discussion

bhaskarpbi9999's avatar
bhaskarpbi9999
Icon for Helper I rankHelper I
1 year ago
Solved

DAX Lookup value function not working to get matching data from two tables.

Hi ,

 

I have two tables stage and leads master but need only matching data based on company as i am using stage table data for our dashbaord

 

Stage Table

 

 

Leads Master

 

 

Calculated column = LOOKUPVALUE('Stage Pipeline'[Account Owner],'Stage Pipeline'[Company],'Leads Master'[Company]))

I have tried using lookup value DAX function but some how it's not workinng

Could you please suggest if there is any alternate solution as there is no join between two tables.

 

Regards,

Bhaskar

 

 

 

Regards,

Bhaskar

 

 

 

 

Need Help
  • bhaskarpbi9999's avatar
    bhaskarpbi9999
    11 months ago

    Hi Pankajnamekar25,

    I am accepting your solution. thanks and kudos for your support.

     

    Regards,

    Bhaskar

     

5 Replies

  • pankajnamekar25's avatar
    pankajnamekar25
    Icon for Super User rankSuper User
    1 year ago

    Hello bhaskarpbi9999 

     

    Try with this calculated DAX column

    Account Owner =
    CALCULATE (
    MAX ( 'Leads Master'[Account Owner] ),
    FILTER (
    'Leads Master',
    'Leads Master'[Company] = 'Stage Pipeline'[Company]
    )
    )

     

    I will suggest to create relationship , if above DAX not working

     


    If my response helped you, please consider clicking
    Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.


    Thanks,


    Connect with me on:

    LinkedIn

     

    • bhaskarpbi9999's avatar
      bhaskarpbi9999
      Icon for Helper I rankHelper I
      1 year ago

      Hi Pankaj

       

      Thanks and kudos for your support. I will try the suggested solution.

       

      Regards,

      Bhaskar

       

       

      Preview
       
       
       
    • bhaskarpbi9999's avatar
      bhaskarpbi9999
      Icon for Helper I rankHelper I
      11 months ago

      Hi Pankajnamekar25,

      I am accepting your solution. thanks and kudos for your support.

       

      Regards,

      Bhaskar

       

  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    Icon for Community Support rankCommunity Support
    11 months ago

    Hi bhaskarpbi9999, 

    Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to pankajnamekar25,  for his valuable insights on this thread.

    I’m using power query to resolve the issue. I used sample data and successfully reproduced your scenario and got worked on my end. So please look into those images which are I shared below.

    You need to replace the value which is shown in the image below:


    The outcome shown in the image below:

    I attached .pbix file here below so please take a look into that.

    Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

    Thank you for using the Microsoft Fabric Community Forum.

    • bhaskarpbi9999's avatar
      bhaskarpbi9999
      Icon for Helper I rankHelper I
      11 months ago

      Hi kpo;oju.

       

      Thanks and kudos for your support. I will try the suggested solution.

      Regards,

      Bhaskar