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     ...
Need Help
  • bhaskarpbi9999's avatar
    bhaskarpbi9999
    11 months ago

    Hi Pankajnamekar25,

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

     

    Regards,

    Bhaskar

     

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