Forum Discussion
Dynamic summarize
Hello, A question that can either be really easy to answer or too difficult. I have a database with Orders; Order numbers, product code, date, quantity sold and various other flags (country, ...
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