Calculate disntnct user domain

[binayjethwa]

Hi , 

I have a requirement in power bi dax. 

I have 2 tables domain and learner activity. 

Domain table has below columns 

1. Domain 

2. Content id 

3. Program 

4. Content title 

Learner activity has below columns. 

1. User id 

2. Content id 

3. Start date 

4. End date. Etc 

Both tables are mapped with Content id as one to many. 

Program column has values respective to particular Domain and also no Program value. 

For example Domain column has agile. And Program column will have programs associated to agile. And sometimes Program column has "no Program " value also.  

Now i want to create a table which shows below 

1. Domain 

2. Users accessing only programs in that domain -[ if user access Domain A and all programs including no Program. Then I do not need him to be counted.  If he access all the programs in particular Domain except no Program in that domain then he is counted. ]

3. And overall users 

 Can some one help in this regard. 

[danextian]

Hi @binayjethwa 

Please provide a workable sample data (not an image), your expected result from the same sample data and your reasoning behind. You may post a link to Excel or a sanitized copy of your PBIX stored in the cloud.

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

[ajaybabuinturi · Accepted solution]

Hi @binayjethwa,
Wanted to let you know that I have created a sample report for your requirement. You can refer Total Users, Users_Only_Program, Users_Only_Program2(to get grand total) measures.

Make sure chose Users_Only_Program or Users_Only_Program2 measure based on your business need.

Here is the .pbix file https://drive.google.com/file/d/1b-gXmTxH3b7Va5Xbu9H7bFgTi2_l_4_s/view?usp=sharing 

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.

[binayjethwa]

Hi @ajaybabuinturi ,

I have few more conditions which need calculations as you shared earlier. atteching below screenshot for reference. Please let me know if we can achieve.

Thanks in advance.

1	User access domain and program with no program also should be counted , basically if in a domain he access only no programs then he is not counted.
2	User access domain and program with no program should be counted , if he access only program completely or only no Program completely in a domain then not counted.
3	User access only no program then he is counted. If he access only programs or program and no program in a domain he is not counted

[binayjethwa]

Thanks Ajay, This worked for me.