Forum Discussion

dogt1225's avatar
dogt1225
Helper III
2 years ago
Solved

Matrix Visual with two measures in a column

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])

 

Need Help
  • _AAndrade's avatar
    _AAndrade
    2 years ago

    Hi dogt1225,

    Please try this formula:

     

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


    I hope this help you.

2 Replies

  • _AAndrade's avatar
    _AAndrade
    Resident Rockstar
    2 years ago

    Hi dogt1225,

    Please try this formula:

     

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


    I hope this help you.

  • Idrissshatila's avatar
    Idrissshatila
    Super User
    2 years ago

    Hello dogt1225 ,

     

    try this 

     

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