power bi: Folder structure downward lookups

[rtillery2000]

I have a folder structure that leads to end results of an object

I can get a lookup going by picking the folder above the object but I can not seem to figure out how to still see the object below when I go two or more folders up.

I have three table to pull this information from. And this needs to be dynamic enough that if another folder layer was added it I would have to make changes.

Think of structure like this:

Top folder

    folder

    folder

        folder

            object

    folder

Table 1 is all folders, objects, and its  associated ID

RoomName	RoomID
customer	5
customer2	6
Customer3	7
Object	2
Room1	13
Room2	12
Room3	11
Lab	4
Room4	8
Room5	9
Room6	10
ROOMS	1
Roomview	3
Root	ROOT

Table 2 is folder map

TreeNodeID	ParentNodeID	Name
7	4	Customer3
6	4	customer2
5	4	customer
4	ROOT	Lab
2	ROOT	Object
1	ROOT	ROOMS
ROOT	-	Root

Table 3 is object map

ParentNodeID	RoomID	Name
6	12	Room2
6	9	Room5
7	11	Room3
5	13	Room1
7	3	Room7
6	8	Room4
5	10	Room6

[v-yuezhe-msft]

@rtillery2000,

Pleae check if the following PBIX file returns your expected result. If not, please share your desired result.

https://1drv.ms/u/s!AhsotbnGu1NolA1QhPgT1WM-Wp_e

Regards,
Lydia

[rtillery2000]

Thanks,

The goal is if you select a higher folder it will show all the rooms in lower folders.

mod the file you made, if you select customer2 the rooms are shown, the goal is to select a folder level higher like lab and shows all rooms in folders below it.

https://1drv.ms/u/s!Ahv5U88PMQayhA3-n8Sz1TpU4bdu

[v-yuezhe-msft]

@rtillery2000,

Please check modified PBIX file.

Regards,
Lydia

[rtillery2000]

Close, when you select Lab it should show the Rooms under Customer, customer 2 and 3

[rtillery2000]

so this is close to working but still not what I am wanting

https://1drv.ms/u/s!Ahv5U88PMQayhA-S1jnsZbQ_qEy7

should be only 2 tables, one with folder structure and one table showing all rooms possible under that folder. (note folders are called nodes for type)

Example if looking at file click lab and the 3rd table shows all the rooms, but if you go up one level to Root it doesn't, I would have to add a 4 table as it stands currently to make that work. this is not dynamic. Kinda need like a feedback relationship

Any help would be greatly appreciated.

[rtillery2000]

I have sadly made no progress on getting this to work