Sum over a parent element of a given child
Greetings, I have a set of data organized like a tree (site > ug > régie > cité > batiment > logement) that represents real estate. A site is a group of UG. UG is managing various "Cité" Régie is not important here. Cité is one or more buildings Batiment is a building Logement is a single room. To each site is assigned a certain number of person working all over the site. (DDE & Postes) DDE links various "Postes" aka jobs over a "site" In the Table Postes (jobs) are defined the names and how much they're getting paid annually. A have a slicer over "Cité" to select a group of building, and taking a simple measure : count of logement_code : will give me the number of rooms all over a group of building. So far, it's quite easy. Now if i drop the "Site"'s name in a pivot table & the same measure: number of rooms. It will give me the same result as the previous pivot table. How can I have a slicer selecting a "Cité" (level 4 of my tree) that affects a pivot table that will show the level 1's name and the amount of rooms all over the level 1 ? Example: I'm sure there's a nice complex DAX formula to make it work. Anyone could help me through ? Thanks a lot ! 🙂 Nicolas
