Add value to top hierarchy level in matrix

[MaxSchrijen23]

Hi all,

I am currently working on a matrix containing a hierarchy. The data I use is a hierarchy of projects and subprojects belonging to this projects. At the same time there are also leades attached to each project and subproject. However, I am only able to show the leaders of the subproject with this hierarchy structure. Is there also a way to show the leaders of the projects in a heirarchy matrix?

Thanks in advance!

[amitchandak]

@MaxSchrijen23 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[MaxSchrijen23]

@amitchandak, yes below are two screenshots of the excel input that I use, which is a snapshot with some fake names and then the power BI output I have. Eventually I have several other attributes to add for each project or subproject such as the enddate, but I geuss that if the issue with the leader is fixed that I am also able to fix the others. Let me know if you need more.

[amitchandak · Accepted solution]

@MaxSchrijen23 , Need some data, But isinscope should be able to help you

refer to this

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

[MaxSchrijen23]

Dear @amitchandak , I tried a lot with this however I am unfortunately still not able to solve my issue. It seems like the functionality refered to in the article only works if you have numeric values with a sum. However, I would need a string value. Do you know if there is a soluton for this? I attached a XLS file and PBI file with my input and my test measures.
Thanks in advance!

https://filedropper.com/d/s/M2ltIzfZsVqEjRYctmQ9ZEucv4YVPv 

[MaxSchrijen23]

@amitchandak, this indeed looks like something I need, thanks a lot!