Forum Discussion
KV2022
Helper II
Helper IISummarizing values
Hi I saw this question in one website. You have a Power BI report named Orders that supports the following analysis: ✑ Total sales over time ✑ The count of orders over time ✑ New and repeat...
hnguy71
Super User
Super UserKV2022 ,
By summarizing the data into a single table, what you would end up with is an extra table that stores and duplicates data from your fact and dimensions. This typically would be called denormalized tables. The question indicates that your shared capacity is nearing its limit for a dataset size so adding "bloat" to your model is not recommended.
In addition, we typically like to "normalize" the model by splitting factual data, considering keys and aggregations, in one table, and attributes in dimension tables to reduce data duplication / redundancy.