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:
Table 1 is all folders, objects, and its associated ID
Table 2 is folder map
Table 3 is object map
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.
Please check modified PBIX file.
so this is close to working but still not what I am wanting
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.