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.

die77777777's avatar
die77777777
New Member
2 years ago

I solved this issue. You need to make a hierarch first in your table. lets say it goes: L0_ID,  L1_ID, L2_ID, L3_ID, L4_ID.

Next drag that into Explain By for Decomposition Tree Visual. 

Now use the code that Curbal Suggests for Matrix in this video:

 

Remove_Blanks = Switch(  True(), 
AND(ISINSCOPE(Hierarchy_Tbl[L0_ID), ISBLANK(VALUES(Hierarchy_Tbl[L0_ID]))) ||
AND(ISINSCOPE(Hierarchy_Tbl[L0_ID), ISBLANK(VALUES(Hierarchy_Tbl[L0_ID]))) ||
AND(ISINSCOPE(Hierarchy_Tbl[L0_ID), ISBLANK(VALUES(Hierarchy_Tbl[L0_ID]))) ||
AND(ISINSCOPE(Hierarchy_Tbl[L0_ID), ISBLANK(VALUES(Hierarchy_Tbl[L0_ID]))),
BLANK(),
COUNTROWS(Hierarchy_Tbl)-1  )

 

and use this Remove_Blanks as the Analyze field in the Decomposition Tree Visual.

janisska's avatar
janisska
Regular Visitor
1 year ago

This is amazing. Thank you! Works like a charm.