Forum Discussion
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] D...
Hi NathanPzi ,
If the relationship is one to many, RELATED function can only be used in the many side table. In other words, 'Grille tarifaire' should be the one side in the relationship.
If not, you can use this formula to reference:
MAXX ( FILTER ( 'table2', 'table2'[column1] = 'table1'[column1] ), [column2] )
Best regards,
Community Support Team_yanjiang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.