Display values from higher hierarchy levels

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

and I have an organisation table similar to the below 

Table_Org

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

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