Summarizing values

[KV2022]

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 customer counts
The data model size is nearing the limit for a dataset in shared capacity.
The model view for the dataset is shown in the following exhibit.

The data view for the Orders table is shown in the following exhibit.

Answer :

Why is the answer No for the first option? 

[v-yanjiang-msft]

Hi @KV2022 ，

Is your problem solved? If so, would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirment will find the solution quickly and benefit here, thank you!

Best Regards,
Community Support Team _ kalyj

[hnguy71]

@KV2022 ,

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.