Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
good afternoon
I have two tables the large table is a direct query table in ssas
the small table is an import table with a few hundred rows.
I join the two
but my next step is to use the dax related function to look up a value in the second small table, but I get
the following error
The column ...................... either doesn't exist or doesn't have a relationship to any table available in the current context. the relationship between the two table is many to one, but I still get the ( ) on the line connecting the two tables and I assume this is because one is a direct query table and the second is an import table.
is this correct, anyway to do the lookup without using the related and without making the first large table into an import table
Hi @djm7 ,
Whether the advice given by danextian and suparnababu8 has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.
Best Regards,
Neeko Tang
Hi @djm7
Yours is a case of a limited relationship
Please see this documentation https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand#limited-...
Alternative (or not), these approaches I couldn't use with SQL server when the calculation crosses between two different source groups:
Proud to be a Super User!
Hi @djm7
I think RELATED dax function doesn't work well across these mixed storage modes. It should be used for same storage modes only.
I am recommending you to use LOOKUPVALUE dax, this fuction may work better for mixed storage sceniories.
Please go through this Solved: RELATED Function with a Direct Query Table - Microsoft Fabric Community accepted solution provided by @johnt75 . You will get the better clarity.
Thanks!
Is the look up in a Measure or Calculated Column?
calculated column
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
125 | |
78 | |
76 | |
59 | |
51 |
User | Count |
---|---|
164 | |
86 | |
68 | |
68 | |
58 |