Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamic relationship table

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 

1 Reply