Parent and child calculation

Hi,

Not 100% sure to understand your needs, but I suppose it's more complicated than your example.

If you need to take into account both levels Parent and Child, you should use 3 variables in your calculation, one for Parent, one for Child and one for Index (could be a date if you have one ?).

And basically you do your calculation, using filters like :

Parent=VARParent && Child=VARChild && IndexValue<=VARCurrentIndex

Hope it's clear enough, otheriwse do not hesitate to come back.

Hi Anonymous ,

You can create a measure as below to get it, please find the details in the attachment.

Output = 
VAR _parent =
    SELECTEDVALUE ( 'Table'[Parent] )
VAR _child =
    SELECTEDVALUE ( 'Table'[Child] )
VAR _tab =
    CALCULATETABLE (
        VALUES ( 'Table'[Child] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Child] = _parent ||'Table'[Parent]=_parent)
    )
VAR _tab2 =
    CALCULATETABLE (
        VALUES ( 'Table'[Parent] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Child] = _parent )
    )
RETURN
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
           'Table'[Child]
                IN _tab || 
                    'Table'[Child] IN _tab2
        )
    )

Best Regards