Project Hierarchy DAX

[JohanData]

Hi guys,

Could you please help me out? It's about the following calculation:

I know how to blank out all the values for the child projects (isinscope), but I don't get the right filter to calculate the right 'total' value (measure).

[v-juanli-msft · Accepted solution]

Hi @JohanData 

Create measures

Measure = IF(ISINSCOPE('Table'[cate]),IF(ISINSCOPE('Table'[sub]),BLANK(),IF([diff]>0,[diff],0)),0)

Measure 2 =
IF (
    ISINSCOPE ( 'Table'[cate] ),
    IF ( ISINSCOPE ( 'Table'[sub] ), BLANK (), IF ( [diff] > 0, [diff], 0 ) ),
    SUMX ( ALLSELECTED ( 'Table'[cate] ), [Measure] )
)

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.