Dynamic relationship table

[Anonymous]

Hi everyone,

I have a datatable:

I want to calculate KPI for objects: Organization, Team, Employee. To accomplish this, I created a parent-child table and used Hierachy-Slicer to decentralize:

To filter and calculate KPIs from the Data table, I created the relationship between the Data table and the Parent-Child table:

By this method, I was able to calculate and use the Slicer to filter data based on the Name column on the Data table for 2 KPIs:

KPI 1 = SUM(data[Value1])

KPI 2 = SUM(data[Value2])

But I have problems with the 3rd KPI:

KPI 3 = SUM(data[Value3])

How can I calculate KPI #3 and still use Hierachy-Slicer to filter the Name2 column in the Data table (KPI 1 and 2 use the Name column)

Thanks you.

pbix file 

[amitchandak]

@Anonymous , refer if these can help

https://radacad.com/parsing-organizational-hierarchy-or-chart-of-accounts-in-power-bi-with-parent-ch...

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Also Refer
https://community.powerbi.com/t5/Desktop/Dynamic-measure-calculation-for-hierarchy-data/td-p/592546
https://community.powerbi.com/t5/Desktop/How-to-create-column-and-row-hierarchies-in-tables/td-p/811...

Please Watch/Like/Share My webinar on Time Intelligence: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-Y...
My Your Tube Tips at: https://www.youtube.com/playlist?list=PLPaNVDMhUXGYrm5rm6ME6rjzKGSvT9Jmy

Appreciate your Kudos.