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] )
)
ribisht17's avatar
ribisht17
Icon for Super User rankSuper User
4 years ago

Anonymous 

 

Regional Countries Count Sol =
if( ISINSCOPE(Orders[Country])=FALSE(),DISTINCTCOUNT(Orders[Country]),BLANK())
 
LOGIC
>>

 

 

 

Please take care of the hierarchy you are using in the calculation because [Parent Case Number] will be true in both the cases

 

 
 
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you for your response ribisht17. Unfortunately it didn't work. When the ISINSCOPE() is false, it shows only the total and blank for both the parent and related case.