Forum Discussion
mim
Advocate V
Advocate VFilter generate is very slow in DirectQuery Mode
I have two Tables, Budget (dimension Table) and Installed Quantity (Fact Tables), linked as multiple to Multiple. Installed Quantity is DirectQuery as it change frequently Budget is import as it ch...
I should have checked this previous answear before
https://community.powerbi.com/t5/Desktop/left-outer-join-using-dax-Multiple-to-Multiple/td-p/218906
amitchandak
Super User
Super Usermim , are these tables not joined in the model on PK, what is the need for generating it in the measure?
If they are already joined on PK then avoid this GENERATE, if you need multiple column join use combinevalues
mimamitchandak how to get a table, that containes two columns from two tables, they are linked on multiple to multiple, so I can't use related ?