Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Remove the Roll-up value from Highest level

Hi 

Can someone please help me with the below question - 
Dataset - 


I have created a hirerachy -- 1) Column1           2) Column2       3)Column3

I would like to remove the rollup at higest level (Column1)





I dont want the value to roll up at higest level, it should be blank  - 

Thanks in advance

Need Help
Show and Tell
Tips and Tricks
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    This sort of situation is where ISINSCOPE can be useful.

     

    If you want it to show only when Column2 or Column3 are in scope, you could write:

    Phase =
IF (
    ISINSCOPE ( Table1[Column3] ) || ISINSCOPE ( Table1[Column2] ),
    SELECTEDVALUE ( Table1[Phase] )
)

2 Replies

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    4 years ago

    This sort of situation is where ISINSCOPE can be useful.

     

    If you want it to show only when Column2 or Column3 are in scope, you could write:

    Phase =
IF (
    ISINSCOPE ( Table1[Column3] ) || ISINSCOPE ( Table1[Column2] ),
    SELECTEDVALUE ( Table1[Phase] )
)