Forum Discussion

jct999's avatar
jct999
Advocate II
4 years ago

DirectQuery + composite model : What can be done ?

Hello I'm going to build the following composite data model: From 2 fact tables: Fact_Table_1: Storage mode = DirectQuery, more than 10M rows Fact_Table_2: Storage mode = Import, 1K lines Crea...
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

I think lbendlin is correct. You can't union the tables without loading Fact_Table_1 into your model.

 

One possible solution is to have both fact tables hooked up to the same dimension tables and define your base measures like this

SumSales = SUM ( Fact_Table_1[Sales] ) + SUM ( Fact_Table_2[Sales] )

This abstracts away the separation for any higher-level measures that depend on such base measures.