I have an issue trying to create a measure that allows me to track the progress for our company’s projects and the related task levels involved with the project.
Dataset: The project management system we are using is called EasyProjects and we are loading a SSAS tabular model from an Azure SQL DB that has replicated data from the EP system.
The problem: We would like to be able to drill from the project progress down to the different task level progress in a Power BI Matrix. Each Project has it is own progress metric (Project Progress). Within each project there is Task Level 1 and a corresponding progress for each task at this level (Task Level 1 Progress). Within Task Level 1 there is Task Level 2 with corresponding progress for those tasks as well (Task Level 2 Progress). Is there a way to construct a measure that can aggregate over this Parent Child relationship that will allow us to drill from the Project Progress down to Task Level 1 Progress and then to Task Level 2 Progress? I have attached a spread sheet that provides an example of the data model as well as the matrix we would like to create in PBI. Let me know if I can clarify anything else and thanks for all the help and great work on this site!
Progress Measures for Parent Child.xlsx (12.8 KB)