Matrix | show totals parent project & blank out child project

[JohanData]

Hi there!

I need some help from you guys 🙂

I'd like to sum up the values and see them only in level 1 (parent) and not in 2 (child). Both columns are in the same table available. 

#Note: a solution with 'hasonevalue' does not work, because project 456 contains only 1 value, so you see a blank for both level 1 (parent) & level 2 (child), which corresponds with the logic of the function.

Test Measure =

VAR a =
CALCULATE ( SUM ( Table[Price] ) )
VAR b =
IF (
HASONEVALUE ( Table[Child ProjectNr] ),
BLANK (),
CALCULATE ( a, ALL ( Table[Child ProjectNr] ) )
)
VAR c =
CALCULATE (
COUNTX ( Table, Table[Child ProjectNr] ),
ALL ( Table[Child ProjectNr] )
)
RETURN
IF ( c = 1, a, IF ( c > 1, b, BLANK () ) )

[Greg_Deckler · Accepted solution]

You probably want ISINSCOPE instead of HASONEVALUE

[v-diye-msft]

Hi @JohanData 

Let me know if you'd like to get below results:

Test Measure = IF(ISINSCOPE('Table'[Child ProjectNr]),BLANK(),SUM('Table'[Price]))

[JohanData · Accepted solution]

Thanks. You made my week ! 🙂

[Greg_Deckler · Accepted solution]

You probably want ISINSCOPE instead of HASONEVALUE