Forum Discussion
Dynamic summarize
What you need is not summarize, but dimension tables linked to fact table to calculate measures based on different segmentation.
Ex: You'd add dimension tables for ordertype, country, calendar etc.
And then link dimensions to fact table (Orders), using column(s) from dimension table as primary and columns(s) from fact table as foreign. This is typically referred to as Star Schema and one of most common ways to structure data model for reporting/analysis.
You can find articles in links:
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
Thank you all for the immediate reply.
I am not really sure if I do need the summary table or not. The reason why I thought I need it, as I mentioned in my first message, is that the same order can have multiple products/countries etc. What I want to create is a dynamic bar chart where in the X-Axis I am having the different numbers of order lines and the number of orders is used as a value. (in the pbi file, I have added the wanted graph)
I am looking at Chihiro reply now. Hopefully, my text above helps you understand my original message.
Thanks again for your time
