Compare and list all rows from table 1 which are not matched in table 2

[zeeshansaeed]

Hi GURU's

I have two tables Table 1 : with unique accounts

table 2 : with account files submitted logs

Table1

  

Table 2

I want to make a powerbi dashboard which will have a filter of Month and Year selection and it will show all the accounts submitted the data for that selected month and year. and i have successfully did it.

The issue is : i need in my dashboard is the name of accounts which havnt submitted the data for that selected month.

I have tried Except but looks like its not working fine as i have multiple data in Table2

Can anyone guide me in the right direction here or can share a sample file for reference to achieve this.

Thanks,

Zeeshan.

[amitchandak]

@zeeshansaeed , Assume A is mater table then

Have measure

cnt = count(TableB[Account ID])

Account not used in the selected period

countx(values(TableA[Account ID]), if(isblank([cnt]) , [Account ID], blank() ) )

[zeeshansaeed]

@amitchandak 

I have tried with 

---

@amitchandak wrote:

@zeeshansaeed, Assume A is mater table then

Have measure

cnt = count(TableB[Account ID])

Account not used in the selected period

countx(values(TableA[Account ID]), if(isblank([cnt]) , [Account ID], blank() ) )

---

its giving me a count but i need account names for these count (FYI - The Count is correct)

All account names which have not submitted the files for selected month

[zeeshansaeed]

Thanks @amitchandak 

is it possible for you to show me with an image how this is done ? sorry i am unable to replicate this.

[amitchandak]

@zeeshansaeed , Same as New in Customer retention , only this is we do not have check for last period. and just normal and sum/count will do

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/b...

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.