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 [Cat] i...
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.

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