Creating self join in a Measure to count the child rows

Hi Anonymous ,

You can create your measures like so:

IF (
    MAX ( 'Table'[Parent] ) <> BLANK (),
    CALCULATE (
        COUNT ( 'Table'[Key] ) + 0,
        FILTER ( ALLEXCEPT ( 'Table', 'Table'[Parent] ), 'Table'[IssueType] <> "EPIC" )
    )
)

total number of "Closed" child of each EPIC =
IF (
    MAX ( 'Table'[Parent] ) <> BLANK (),
    CALCULATE (
        COUNT ( 'Table'[Key] ) + 0,
        FILTER ( ALLEXCEPT ( 'Table', 'Table'[Parent] ), 'Table'[Status] = "Closed" )
    )
)

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.