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.

_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.