Forum Discussion

luna_82's avatar
luna_82
Frequent Visitor
8 years ago

hierarchy levels

Hi!   it's possible to have diferent levels of hierarchy in the same Matrix for diferent rows?.   For example, i have 4 levels , L1, L2, L3, L4 but not all the levels have all.     L1   L2  <...
MFelix's avatar
MFelix
Super User
8 years ago

Hi luna_82,

 

Not reaaly sure how you make the link between CAPEX NG and CAPEX G and the other level,  is it based on what column?

 

Regards,

MFelix

luna_82's avatar
luna_82
Frequent Visitor
8 years ago

 

CAPEXG and CAPEXNG are parents . 

 

Sorry because the column header is crop. The first column  is Id, next ParentId, description, and the last one is a code. 

 The expected result will be something like that , the green are the leaf nodes....,

 

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi luna_82,

     

    I have some work related time constraints will look at this ASAP.

     

    Sorry for the time.

     

    Regards,

    MFelix

    • luna_82's avatar
      luna_82
      Frequent Visitor
      8 years ago

      thank you MFelix !!!

      • MFelix's avatar
        MFelix
        Super User
        8 years ago

        Hi luna_82,

         

        Although I have send you the solution by private message last month I was only abble to provide the soluiton here now.

         

        I refered to this article from marcorusso, in this article the hierarchy are calculated based on the path that each hierarchy level has then based on that we do a lookup of the previous level.

         

        The several levels of hierarchy are calculated in hidden columns then we use to make the final calculations based on the measure we need.

         

        Check the article in detail and the PBIX file attach with the solution.

         

        Regards,

        MFelix