ISINSCOPE Function Not Working

[Mahesh0016]

Hello Community,

> I have one problem with the isinscope it's not working properly. 
For E.g I have two tables  A and B that have one too many relationships Table A [Account ID] to Table B [Account ID].

Table A

Account ID	Account Name
1	D
2	P
3	A
4	M
5	R

Table B

Project ID	Account ID	Project Name
1	1	ABC
2	1	XYZ
3	1	PQR
4	2	STU
5	2	LMN
6	2	OPQ
7	3	DEF
8	3	GHI
9	4	JKL
10	4	MNO
11	5	WXZ
12	5	ADS

Here Problem is when i plot accont name and Prject name in matrix hierarchy then i plot measure isinscope(Table A [Account Name]) it's give me result like below SS:

Measure is :
 IsinScope Account Name =
ISINSCOPE ( Account[AccountName] )

> My Expected out put like below SS:
 

Account Name	IsinScope Account Name
A	True
DEF	False
GHI	False
D	True
ABC	False
PQR	False
XYZ	False
M	True
JKL	False
MNO	False
P	True
LMN	False
OPQ	False
STU	False
R	True
ADS	False
WXZ	False

[vivek31]

Hi @Mahesh0016 
try this,

[Anonymous]

Use It,
IsinScope Account Name =
NOT(ISINSCOPE(Account[AccountName]))

[SamInogic]

Hi @Mahesh0016 ,

You can check if the scope is account and not the project to get expected output, so create a measure with below DAX expression,

IsinScope Account Name =

ISINSCOPE('Table A'[Account Name]) && not ISINSCOPE('Table B'[Project Name])

Please refer to the below screenshot for the same,

Thanks!

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at crm@inogic.com

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

[Mahesh0016]

@SamInogic Thank you, it is right but in my case, I have no blank value.

so in that case what I do, please guide me. Thank You!!

[SamInogic]

Hi @Mahesh0016 ,

As you mentioned tables in question, we have used the same table data.

These are not blank values when we use matrix and add Account from Table A and Project Name from Table B in Rows, it joins two table. You can try to add the “Account ID” column in Values section of matrix and able to see blank cells as shown in below screenshot.

For example, for Account “A”, available projects are DEF and GHI but in matrix you will be able to see all list of project with Account ID column only contain count 1 for DEF and GHI. So Measure “” helps you to get appropriate data as mentioned in above steps.

Let me know if this works for you or else could it be possible to share a sample .pbix file so we can check and help you resolve the issue?

Thanks!

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at crm@inogic.com

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

[Mahesh0016]

@SamInogic 
Thank you for your reply but it is not my Expected output.

This is my Expected output. Thank You!!

[SamInogic]

Hi,

Ok, to filter out your result you need to create a measure with below DAX expression,

CountAccountIDs = COUNT('Table B'[Account ID])

Then Add this measure to the filter condition of the table as

CountAccountIDs is not blank

Please refer to the below screenshot,

Thanks!

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at crm@inogic.com

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/