Forum Discussion
How does aggregation table get populated?
Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.
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.