Creating Aggregated table which is based on import fact table and Direct Query Fact table.

[Anonymous]

Hi,

I have a model in which, I have two fact tables. based on granuality. FactBrand is using Import mode based on (Total,company and Brand level data) and FactItem is using Direct query which have (item level data). All the dimension files are no import mode. All I want to create an Aggregation table which uses import mode when Total,company or brand is selected and Uses direct query when Item level selected. I am struggling how can I connect both fact table, So that I can write a single measure which works fine with both table. How can I create AGG based on two fact tables.

** Column names are same in both fact table.

[pbiforum123]

Did you got any solution? How did you overcome this?

[Anonymous]

Hi,

Thanks for the reply. Actually, I need to know how can I give reference to the combination of imported and DirectQuery tables. Do I need to combine these two tables in power query? Can you please give me an example?

Regards,

Anupam

[v-easonf-msft]

Hi, @Anonymous 

You can consider adding another calculated tables to a model that uses DirectQuery.

The Data Analysis Expressions (DAX) that define the calculated table can reference either imported or DirectQuery tables or a combination of the two.

Please refer to below document for more details.

Calculated tables 

Best Regards,
Community Support Team _ Eason