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...
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] )
)
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] )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    thank you AlexisOlson