Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello! First, sorry for my English) I wil use pictures. I have a data by cities and regions, but they are together:
I want to see the cities data added into the corresponding region rows. For example, like the Trenton inside the New Jersey,
I founded three tables with cities, regions and countries:
Also I have made some transform:
It gives me a chance to satisfy my need.
Next I connected the main table to city table:
Then I try to configure my table view:
As a result:
And if I scroll:
How can I see the "Архангельская обл." (I already fixed it) "Архангельская область" data in one row with sum=118791+384786+47289+18217+121382 ?
In this scenario, you have fact data on both region level and city level. You need to build a "parent-child hierarchy" for REGION-CITY so that you can aggregate region itself and its child level together. Please refer to blog below:
Regards,
Thanks for the answer. I read it fluently and I have a question. Analogy with parents is good. If we speak in terms of sales, in my situation children and their parents sell both. And i have the situation:
(Oops! At the screen I should write Bill: 10+1+4+2+1)
Will I reach this goal using parent-child hierarchies?
If yes, I'll study this in more detail.
Yes, you are correct. The aggregation for parent level will include themselves. If the parent level has fact data, it will appear along with child members as well. Like the last image in that link:
You should build the Parent-Child hierarchy for your scenario.
Regards,
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |