Forum Discussion
SUMX expression doesn't hit live query in aggregation data model
Hi Anonymous ,
In you scenario, the base data in aggregration table is filtered, not the same as your fact table. And the column you used is contained in the aggregration table. So the result comes directly from the aggregate table, not from the fact table.
Simply put, the basic data in the fact table and the aggregration table must be the same. We can't use the filtered fact table as an aggregration table.
Therefore, in your aggregration table, all data should be contained, not just 90 days of data.
I wonder if I explain it clearly.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi Anonymous ,
In you scenario, the base data in aggregration table is filtered, not the same as your fact table. And the column you used is contained in the aggregration table. So the result comes directly from the aggregate table, not from the fact table.
Simply put, the basic data in the fact table and the aggregration table must be the same. We can't use the filtered fact table as an aggregration table.
Therefore, in your aggregration table, all data should be contained, not just 90 days of data.
I wonder if I explain it clearly.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.