Forum Discussion
How does aggregation table get populated?
Hello, I am trying to figure out aggregation tables and apparently missing something obvious... I created a super-simple model with 2 tables, orderlines and product. I would like to test grouping inc...
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.