Forum Discussion
Using Path to filter table showing only PathContains Data
- 5 years ago
Ok. I was able to resolve this
1. Created a disconnected table of the original table, lets call it tableB
2. created a calculated column 'Path' in tableB
3. created an additional calculated table tableC, with union of 4 levels of pathitems eg.
var _table = SUMMARIZE(tableB, Name,Parent,Path) var _table1 = UNION( ADDCOLUMNS(_table, "Entity", PATHITEM(Path, 1, TEXT)), ADDCOLUMNS(_table, "Entity", PATHITEM(Path, 2, TEXT)), ADDCOLUMNS(_table, "Entity", PATHITEM(Path, 3, TEXT)), ADDCOLUMNS(_table, "Entity", PATHITEM(Path, 4, TEXT)) ) return SUMMARIZE(_table1, [Entity],Name)4. Created a bidirectional relationship between tableC 'Name' and tableA 'Name'
5. Using Entity as Slicer, I was able to create filter childs of that group.
Ok. I was able to resolve this
1. Created a disconnected table of the original table, lets call it tableB
2. created a calculated column 'Path' in tableB
3. created an additional calculated table tableC, with union of 4 levels of pathitems eg.
var _table = SUMMARIZE(tableB, Name,Parent,Path)
var _table1 = UNION(
ADDCOLUMNS(_table, "Entity", PATHITEM(Path, 1, TEXT)),
ADDCOLUMNS(_table, "Entity", PATHITEM(Path, 2, TEXT)),
ADDCOLUMNS(_table, "Entity", PATHITEM(Path, 3, TEXT)),
ADDCOLUMNS(_table, "Entity", PATHITEM(Path, 4, TEXT))
)
return
SUMMARIZE(_table1, [Entity],Name)
4. Created a bidirectional relationship between tableC 'Name' and tableA 'Name'
5. Using Entity as Slicer, I was able to create filter childs of that group.