Data & hierarchy adaption

[SimonGrams]

Hi guys,

I have some problems showing the correct data in a visual and simultaneously display Filters in a required hierachy. 

My data looks like this (on a weekly basis):

Data

Year	Week	Levels	Sessions
2017	14	A0	489
2017	14	A1	547
2017	14	A2	295
2017	14	A3	447
2017	14	A4	366
2017	14	B0	316
2017	14	B1	398
2017	14	B2	280
2017	14	C0	499
2017	14	C1	512
2017	14	C2	480
2017	14	C3	496
2017	14	D0	416
2017	14	D1	524
2017	14	D2	408
2017	14	D3	263
2017	14	D4	270

These levels are different product categories from an online shop.

These categories subdivide as in the LookUp table:

LookUp (hierarchy)

Level 1	Level 2	Level 3	Level 4	Level 5
A0	-	-	-	-
A0	A1	-	-	-
A0	A1	A2	-	-
A0	A1	A2	A3	-
A0	A1	A2	A3	A4
B0	-	-	-	-
B0	B1	-	-	-
B0	B1	B2	-	-
C0	-	-	-	-
C0	C1	-	-	-
C0	C1	C2	-	-
C0	C1	C2	C3	-
D0	D1	-	-	-
D0	D1	D2	-	-
D0	D1	D2	D3	-
D0	D1	D2	D3	D4

Desired result:

5 Filters, which display the hierarchies / adapt to the chosen levels

Problem:

If I create a relationship between the data and the LookUp table and choose e.g. A0, the other Level-filters adapt to my choice beautifully, but the "Sessions"-Measure sums up all levels which "belong" to A0 (A1 to A4).

I just want the sessions of the chosen filter, here A0 (& the filter-adaption) - like I get by choice of "-" in level 2:

Is there any possibility to get the desired output & the filter hierarchy-adaption / do I have to create a new Session-Measure?

Thanks in advance...

[Anonymous]

Hi @SimonGrams,

Do you display raw structure and data of your tables in the above screenshot? If so, which columns do you use to create relationship between  the two tables? Do you want to show 489 when selecting the A0  in Level 1 slicer and selecting - in Level 2 slicer?

Thanks,
Lydia Zhang