Get values which are not present in the filtered main list from another list

[Tony09]

Hello,

I have the main list which contains data with the following columns

Main list

Title.             Region

A1.                Region1

B1.                Region5

C1.                Region4

C1.                Region3

A1.                Region7

A1.                Region3

D3.                Region3

In this main list all the regions should submit the data for all the titles. 

Second list has the list of 60 regions 

Title

Region1

Region2

Region3..............

Now In PowerBI I am displaying how many regions have responded for particular title from main lis.

I want to show how many regions haven't responded yet based on the title selection from main list.

Any suggestions will be helpful.

Thank you 

[JoeBarry · Accepted solution]

Hi @Tony09 

There should be a relationship between both tables on the Region columns 

Add the Regions from table 2 to a table visual and then add the region column from the first table and do a count on this. Turn this on 

You will then see blanks where no Region has been entered. You can then filter in the filter pane just for blanks

Thanks

Joe

If this post helps, then please Accept it as the solution

[Tony09]

Thank you so much @JoeBarry 

It worked 😊