Forum Discussion

JohanData's avatar
JohanData
Resolver I
6 years ago
Solved

Project Hierarchy DAX

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 ...
Need Help
Show and Tell
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    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.

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

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.