topic Re: ISINSCOPE issue in matrix in DAX Commands and Tips

ISINSCOPE issue in matrix

Anonymous — Fri, 27 May 2022 01:10:49 GMT

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 for a parent case and show this only on the first hierarchy, which is the parent case. Currently, the measure only eliminates the total. I've read other posts and possible solution but nothing is working, not quite sure why. Thanks in advance.

Data:

Re: ISINSCOPE issue in matrix

tamerj1 — Fri, 27 May 2022 02:54:41 GMT

Hi Anonymous

please use

Related Case = IF ( NOT ISINSCOPE ( Query1[Related Case Number] ), COUNT ( Query1[Parent Case Number] ) )

Re: ISINSCOPE issue in matrix

ribisht17 — Fri, 27 May 2022 05:32:23 GMT

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

Re: ISINSCOPE issue in matrix

Anonymous — Fri, 27 May 2022 12:23:30 GMT

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.

Re: ISINSCOPE issue in matrix

Anonymous — Fri, 27 May 2022 12:24:19 GMT

This works perfectly. Thanks a lot tamerj1!