Forum Discussion

vanguard2x2's avatar
vanguard2x2
New Member
4 years ago
Solved

Get multiple ID columns into one column in a matrix

Greetings everyone,  I want to combine multiple (two) columns that have parent/child relationship into one column when drilling down in a matrix. Let me give an example - the matrix looks like this ...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    You could try

    Combined ID =
IF (
    ISINSCOPE ( 'Phase'[Name] ),
    SELECTEDVALUE ( 'Phase'[Phase ID] ),
    IF ( ISINSCOPE ( 'Program'[Name] ), SELECTEDVALUE ( 'Program'[Program ID] ) )
)
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

You could try

Combined ID =
IF (
    ISINSCOPE ( 'Phase'[Name] ),
    SELECTEDVALUE ( 'Phase'[Phase ID] ),
    IF ( ISINSCOPE ( 'Program'[Name] ), SELECTEDVALUE ( 'Program'[Program ID] ) )
)