Forum Discussion

ZakD's avatar
ZakD
Frequent Visitor
2 years ago
Solved

Assistance Needed with Lookup Function Issue in Power BI

Dear Power BI Community,   I hope this message finds you well.   I am currently facing a challenge with a lookup function in my table view within Power BI. Although the function operates correctl...
Need Help
  • ZakD's avatar
    ZakD
    2 years ago

    Among the solutions considered, I have selected the DAX function (MINX and FILTER). As a reminder, this is the  formula syntax:

    ---------------------------------------------------------------------------------------------------------------
    ResultColumn = MINX(
    FILTER(
    Table2,
    Table2[ID] = Table1[ID]
    ),
    Table2[ValueToLookup]
    )

     

    Thanks again HotChilli for your support, I could sort this thanks to your guidance.

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
2 years ago

Ah, good, now we are into weird territory.

Do you have a relationship between the tables? Can you test by making the relationship inactive?

As a test, can you try and merge inner join on 1564 in Power Query to see if it works?

Can you write alternative dax to test without using lookupvalue (i.e. MIN with a FILTER)?

These are the sort of things I would look at.

---

I've read posts over the years of LOOKUPVALUE behaving like this and people have suggested a data refresh problem or a relationship interfering. I suppose it's possible.  Maybe we can solve it here for everyone.