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 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