Direct Query Relate to Other Table

[jzhao]

I imported a data model using DirectQuery and I want to convert revenue using the plan rate with a function.

I'm using the following formula:

Revenue at USD Plan = DIVIDE(Fact_Backlog[Revenue in local currency], RELATED('Plan Rate Lookup'[FY 24 Plan Rate]))

However, I am encountering an error: The column 'Plan Rate Lookup[FY 24 Plan Rate]' either doesn't exist or doesn't have a relationship to any table available in the current context.

The relationship appears to be set up correctly. How can I resolve this issue? I understand that I'm working with DirectQuery, but the table relationships seem fine.

Maybe the reason is the fact table is a direct query and a lookup table is import model. Is there a way create relationship between direct query and import model?

[jzhao]

Huh? Row context is iterating the table on the many-side of a relationship(fact table) . and I use related to retrieve unique value from lookup table. The data model and usage is identical to the article.

 Using RELATED and RELATEDTABLE in DAX - SQLBI

[Anonymous]

Hi @jzhao ,

Sorry my bad, I had it backwards, I'll delete my reply. But maybe you still need to provide your sample data to know what the problem is. Apologies!
Also I see that your table seems to be still connected to other tables, please check if there are other propagation paths between your table Fact_Backlog and table Plan Rate Lookup (i.e. there is a closed loop relationship between these two tables), if so, that could potentially lead to an unclear passing relationship.

Best Regards
Dino Tao

[lbendlin]

I imported a data model using DirectQuery

Huh?

RELATED is not normally something you use in a measure.  Is your formula addressing columns or measures?

[jzhao]

This is calculated column