Forum Discussion
How does aggregation table get populated?
Not so easy for me to share the data. But it is quite simple, I have 2 tables which use DirectQuery storage mode, orderline and product. Orderline table contains productid and totalamount. Product table contains productid and name columns. A relationship exists on productid. I want to create an aggregation table which contains Sum and Product name columns and create a simple visual which shows sum per product. Should PowerBI automatically populate my aggregation table or not? When I configure my aggregation table (which is created manually by using "Enter data" in powerquery window) and click "Apply all", the table is hidden as it should be, but no data gets into the table automatically.
Anonymous ,You will have that in visual. No need of new tbale. if you drag product name from product and totalamount from order it will by deafult the aggregation on number is sum, else right click on the column (should drag in values in case of matix) and change aggregation .
or create a measure
totalamount m = sum(Order[totalamount])
and use that.
amitchandak , I know I don't really need aggregations table in this simple scenario, but I am in learning process and trying to understand how aggregations work. Suppose that my orderline table contains millions of rows and that I want to group by not only the product, but region, customer, day of the week... I am trying to make a simple as possible example to see how it works and test it.