Forum Discussion
Super UserManage aggregations multiple fact tables DirectLake over OneLake
Hello Jacek,
In aggregatinos tables, the user cannot force which table is used. If they select “Month” in a slicer, the engine may still query the daily table if the visual structure doesn’t match the aggregation definition.
Aggregations are designed for performance optimization, not user-driven logic. But in calculation groups there is explicit user control, the slicer dictates exactly which table is queried.
Best,
Anıl
Super UserHello Jacek,
In aggregatinos tables, the user cannot force which table is used. If they select “Month” in a slicer, the engine may still query the daily table if the visual structure doesn’t match the aggregation definition.
Aggregations are designed for performance optimization, not user-driven logic. But in calculation groups there is explicit user control, the slicer dictates exactly which table is queried.
Best,
Anıl
Super Userthank you.
This is great answer!
- anilelmastasi
You are welcome Jacek, could you please accept as solution 🙂