Forum Discussion
Direct Query Relate to Other Table
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 lo...
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.
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