Forum Discussion

campelliann's avatar
campelliann
Icon for Post Patron rankPost Patron
5 years ago

Lookupvalue returning the complete column in blanks

Hi, So I have this fact table which unrelated to a lookup table, and I am extracting values from the latter using the lookupvalue. The thing is that I am getting all blanks, and I have no idea ...
dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
5 years ago

Hi campelliann - can you provide the code you are using, along with a sample of your data? Hard to know what is happening without specifics.

 

Or better yet if you can share a copy of your pbix with sensitive data removed. Use OneDrive, Googledrive, dropbox, etc to share a link.

 

David

campelliann's avatar
campelliann
Icon for Post Patron rankPost Patron
5 years ago

hi dedelman_clng, thanks for your reply. The problem is that the complete file is sensitive. I did a new table, where I filtered the IDs from the first Table, to get only those who are common in both tables. In this way the lookupvalue worked. It seems the cause were the IDs that were non-existent in the table from which I am extracting the field.

Does this help? 

  • dedelman_clng's avatar
    dedelman_clng
    Icon for Community Champion rankCommunity Champion
    5 years ago

    HI campelliann - can you provide a screenshot of the table structure (from the model screen, not the data) and the code you are using with LOOKUPVALUE ?  It may be a simple fix that doesn't require creation of a 3rd table to work.

    • campelliann's avatar
      campelliann
      Icon for Post Patron rankPost Patron
      5 years ago

      I want the field "orçamento" from fields. So Lookupvalue(Fields orçamento [orçamento], Fields orçamento [ID], Beebole completo [Project ID]).  It seems that the IDs that live on Beebole but not on Fields orçamento are messing this. dedelman_clng 

      • dedelman_clng's avatar
        dedelman_clng
        Icon for Community Champion rankCommunity Champion
        5 years ago

        Hi campelliann -

         

        You said initially that you were using 0 as an alternate result, but your code

         

        Lookupvalue(Fields orçamento [orçamento], Fields orçamento [ID], Beebole completo [Project ID])

         

        does not have that alternate result. 

         

        Aside from that, given that I can't see the rest of your model, it is possible that there are other filters in play that you are not aware of on either or both of the tables. You could try this:

         

        CALCULATE(
   Lookupvalue(Fields orçamento [orçamento], 
               Fields orçamento [ID], 
               Beebole completo [Project ID], 0),
   ALL(Fields orcamento)
)

         

        Beyond that, without the context of seeing the entire report, I don't think there is much else I can help with.

         

        David