Forum Discussion

masplin's avatar
masplin
Icon for Impactful Individual rankImpactful Individual
3 years ago

Looking up data from another model in a joint model

Hi. Really stuck on this.  I have 2 models, one is a CRM system thatrecords client aquistion unti lthey start.  The other is a transaction system that takes over once they start.  My issue is that cu...
Need Help
sturlaws's avatar
sturlaws
Icon for Resident Rockstar rankResident Rockstar
3 years ago

From the documentation of LOOKUPVALUE:

LOOKUPVALUE function (DAX) - DAX | Microsoft Learn

  • This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

 

Why do you need it as a calculated column? Could you make do with a measure, and show the start date pr customer in a table visual?

 

Cheers,
Sturla



masplin's avatar
masplin
Icon for Impactful Individual rankImpactful Individual
3 years ago

I'll try as a maeausre, but seemed obvious to just add an extra column as its static data and only needs calcuating once.   Can you build cvombined models without using direct query?  The underlying models are only updated every week so there is no "live" data anywhere.

  • sturlaws's avatar
    sturlaws
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    If you are working with direct query, it is not static anyways, it will always be calculated by the query which is generated whenever you do something that filters a visual.

     

    The alternativ to direct query is import mode, but I don't think you can switch from one to the other, you would have to create a new file.

    • masplin's avatar
      masplin
      Icon for Impactful Individual rankImpactful Individual
      3 years ago

      I tried creating anew file, but it didnt give me an option of import mode when I choose PowerBI datasets just does Direct query automoatically. really irritating. I'll try to write a measure as that seems to work ok across tables