Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

ISINSCOPE issue in matrix

Hello,   I have one very simple measure that I have followed in other posts. With this measure, I want to remove the count for the 2nd hierarchy. I would like to count the number of related case fo...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 

    please use

    Related Case =
IF (
    NOT ISINSCOPE ( Query1[Related Case Number] ),
    COUNT ( Query1[Parent Case Number] )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous 

please use

Related Case =
IF (
    NOT ISINSCOPE ( Query1[Related Case Number] ),
    COUNT ( Query1[Parent Case Number] )
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

This works perfectly. Thanks a lot tamerj1!