Forum Discussion
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:
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.
1 Reply
- amitchandakSuper User
Anonymous , refer if these can help
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/81168Please Watch/Like/Share My webinar on Time Intelligence: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
My Your Tube Tips at: https://www.youtube.com/playlist?list=PLPaNVDMhUXGYrm5rm6ME6rjzKGSvT9Jmy
Appreciate your Kudos.