Reply
NathanPzi
Frequent Visitor
Partially syndicated - Outbound

DAX Relation between DirectQuery and Import

Hello,
I have a report that contains multiple tables, one is in 'Import' mode, and the other is in 'DirectQuery' mode and is linked to another report.
Import: Grille tarifaire[Moyenne]
DirectQuery: Affaire[TJM Vendu]
I'm trying to create a calculated column with this function: Flag TJM PFSA = if(RELATED('Grille tarifaire'[Moyenne]) = BLANK(), 5, if(RELATED('Grille tarifaire'[Moyenne]) >= Affaire[TJM Vendu],1,10))

But Power BI is giving me this error: The column 'Grille tarifaire[Moyenne]' either doesn't exist or doesn't have a relationship with any table available in the current context.

However, I have established a relationship between the two tables using a reference, and the relationship is active with the correct cardinality.
And when creating the column using "RELATED", Grille tarifaire shows up as a suggestion.

If anyone has any tips or a solution to my problem, I would greatly appreciate it.

Thank you 🙂

1 ACCEPTED SOLUTION
v-cgao-msft
Community Support
Community Support

Syndicated - Outbound

Hi @NathanPzi ,

 

vcgaomsft_0-1685415393286.png

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 Team

 

If 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

View solution in original post

2 REPLIES 2
v-cgao-msft
Community Support
Community Support

Syndicated - Outbound

Hi @NathanPzi ,

 

vcgaomsft_0-1685415393286.png

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 Team

 

If 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

lbendlin
Super User
Super User

Syndicated - Outbound

Please show your data model. RELATED only works on the "Many" end of a 1:M relationship with single search direction.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)