Forum Discussion

Suganthy's avatar
Suganthy
New Member
4 years ago
Solved

Using Decomposition Tree as Organization chart

Hi All,    I am trying to use the decomposition tree  as an org chart, and below is how the data that am trying to use    Unique Identifier Level Department Ultimate parent  Parent Level ...
  • lbendlin's avatar
    lbendlin
    4 years ago

    Use the DAX PATH functions, and ISINSCOPE() to suppress blanks.

RealSir's avatar
RealSir
Frequent Visitor
3 years ago

In your table create a column 'IsLeaf':

IsLeaf = 1*(ISBLANK(LOOKUPVALUE([Parent],[Parent],[Name])))

 

Leaf can't be a parrent, so it checks if given member exist on parent list, if it doesn't the result of lookup is blank. Add that to your visual as a filer and set it to be eaqual 1.