Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

direct query and import tables

good afternoon   I have two tables the large table is a direct query table in ssas the small table is an import table with a few hundred rows. I join the two  but my next step is to use the dax ...
Need Help
suparnababu8's avatar
suparnababu8
Icon for Super User rankSuper User
1 year ago

Hi Anonymous 

 

I think RELATED dax function doesn't work well across these mixed storage modes. It should be used for same storage modes only.  

 

I am recommending you to use LOOKUPVALUE dax, this fuction may work better for mixed storage sceniories.

Please go through this Solved: RELATED Function with a Direct Query Table - Microsoft Fabric Community accepted solution provided by johnt75 . You will get the better clarity.

 

Thanks!