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
danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

Hi Anonymous 

 

Yours is a case of a limited relationship

  • many-to-many
  • from one source group to another (import to direct query and vice versa)

  •  

Please see this documentation https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand#limited-relationships 

 

Alternative (or not), these approaches I couldn't use with SQL server when the calculation crosses between two different source groups:

  • LOOKUPVALUE
  • RELATED
  • CALCULATE(....FILTER(...
  • measures that try to propagate a virtual relationship - using TREATAS or table1[column] in values(table2[column)
  •