Forum Discussion
Custom Item Hierarchy
All, I am stuck on a project I'm working on. What I am trying to do is create a custom hierarchy for items and am not sure how to model the data. I am currently setting up my table to look l...
Power Pivot uses DAX. Yes it applies to Power BI.
Are you reviewing the Complete Pattern? The only other bit that's not in the article, it's in the comments, is :
BrowseDepth:=
ISFILTERED ( Nodes[Level1] )
+ ISFILTERED ( Nodes[Level2] )
+ ISFILTERED ( Nodes[Level3] )MaxNodeDepth:=MAX ( Nodes[HierarchyDepth] )
If I recall correctly.
Then you'll make your own hierarchy to drag and drop Levels.
How do I set up the nodes key and parent key for my table?