Display values from higher hierarchy levels

[worthywow1988]

Hi,

After a bit of help!

I'm working with summary data extracted from a system we are using. The data is summarised at different levels in the organisation

Table_Scores

Org Level	Org Name	Average Score
1	Company 1	6.5
2	Division XYZ	8.6
3	Business Unit 12	7.7
3	Business Unit 23	8.9
etc.

and I have an organisation table similar to the below 

Table_Org

Org Level 3	Org Level 2	Org Level 1
Business Unit 12	Division XYZ	Company 1
Business Unit 23	Division XYZ	Company 1
Business Unit 34	Division ABC	Company 1
etc.

Note I only have the summarised scores for each level so can't calculate it bottom up which I'd usually do.

I'm trying to create a dashboard where the user selects the org level 3 of interest using a slicer and then show three cards at the top showing the scores for the level plus it's parent levels

Org Level 3 : Business Unit 12 : Score 7.7

Org Level 2 : Division XYZ : Score 8.6

Org Level 1 : Company 1 : Score 6.5

At the risk of pushing my luck it would be good to have a bar chart showing the three values.

I guess what might faciliate this is a summary table that updates according to the slice and stores the values?

I've tried a few approaches and got close but nothing seemed to work 😞

Any help/ideas really appreciated!

Richard

[v-xinruzhu-msft]

Hi @worthywow1988 

Did the solution dufoq3 offered help you solve the problem, if it helps, you can consider to mark it as a solution so that more user can refet to.

Best Regards!

Yolo Zhu

[worthywow1988]

Hi @dufoq3 

Really appreciate you taking the time to help and creating the example - many thanks. I'll give this approach a go and report back!

Thanks again!

[dufoq3 · Accepted solution]

Hi @worthywow1988, you can create something similar: