none
Parent Member can not be sum of the children

    Question

  • Hello to every body,

        could You pls help me to  create a calculation in DAX where  the value for children are sum but for parents are taken  from the source table . For parents the data is aggregated in the source table but is not for children. The hierarchy has about ten levels. Version of SSAS is 2016. 

    Thank You for help

    Wednesday, May 16, 2018 1:54 PM

All replies

  • Hi Torro44,

    Thanks for your question.

    >>> could You pls help me to  create a calculation in DAX where  the value for children are sum but for parents are taken  from the source table . For parents the data is aggregated in the source table but is not for children.
    If I understand you correctly, you are trying to implement parent-child hierarchies, right? If so, please refer to a blog below talking about parent-child hierarchies:
    https://www.daxpatterns.com/parent-child-hierarchies/

    If you are trying to handle measure based on different hierarchy level, then you can try to use DAX function ISFILTERED, see below blog talking about hierarchy in SSAS tabular:
    https://www.sqlbi.com/articles/clever-hierarchy-handling-in-dax/


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Thursday, May 17, 2018 2:33 AM
    Moderator