Matrix Visual with two measures in a column

[dogt1225]

I have a matrix visual where the parent Category is Products and Sub Category is Engineer Name. (Infomation has been cutoff in screenshot for security purposes. )
I have two measures

1. [Cat] is the percent of total by Product
2. [SubCat] is the percent of total by Engineer within each Product. 

I am looking to create a combines column (last column within the screenshot), that only shows the [Cat] values when the hierarcy in the matrix is minimized and show both [Cat] and [SubCat] when the matrix is expanded to next level. 

With my current calculation the SubCat values are not appearing and showing all zeroes. 

Combine = 
IF(ISFILTERED('Volume'[Engineer Name]), [Cat], [SubCat])

[_AAndrade · Accepted solution]

Hi @dogt1225,

Please try this formula:

Combine = 
IF(
    ISINSCOPE('Volume'[Engineer Name]),
    [SubCat],
    [Cat]
)

I hope this help you.

[Idrissshatila]

Hello @dogt1225 ,

try this 

Combine = 
IF(
    ISINSCOPE('Volume'[Engineer Name]),
    [Subcat],
    IF(
        ISINSCOPE('Volume'[Category]),
        [Cat]
        
    )
)