Forum Discussion
DAX Relation between DirectQuery and Import
Hi NathanPzi ，
Depending on where you create the calculated column; they can have some limitations. If you create a calculated column in an Import table or a calculated table, then there will be no limitation. However, if you create a calculated column in a DirectQuery table, then in the expression for the column only columns from the same table can be used.
Composite Model in Power BI; DirectQuery and Import Data Combined - RADACAD
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Super UserPlease show your data model. RELATED only works on the "Many" end of a 1:M relationship with single search direction.