Guide to DAX Ch 11: Handling Hierarchies Flashcards
1
Q
What does the ISINSCOPE function do?
A
Returns TRUE if column is filtered and is part of the columns used to perform a grouping.
2
Q
When writing IF statements for a hierarchy, which level of the hierarchy do you start with?
A
The innermost, or the lowest and work your way out or up.
3
Q
What does the PATH function do?
A
It takes the item key and the parent key and performs a recursive traversal of the table. For each node it builds the path as a list of keys separated by a pipe(|) character.
4
Q
What does the PathItem function do?
A
Returns items at the nth level of the hierarchy (1 is the highest level.
5
Q
What is the difference between a leaf node and a non-leaf node?
A
Leaf nodes have no values associated with them; non-leaf nodes have values associated with them.
