Outer Join in a Composite Model

TePe ,

There're several limitations of data model regarding direct query mode. For example, the bidirectional cross filtering is not supported in direct query mode. In general, I would suggest you use other expressions instead of related function. For exmaple, use pattern like below:

value =
VAR Current_Id = largetable[Id]
RETURN
    IF (
        ISBLANK ( largetable[default_field] IN VALUES ( smalltable[lookup_field] ) ),
        largetable[default_field],
        CALCULATE (
            MAX ( smalltable[lookup_field] ),
            FILTER ( smalltable, smalltable[Id] = Current_Id )
        )
    )

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.