Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Tony09
Frequent Visitor

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

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 

1 ACCEPTED SOLUTION
JoeBarry
Solution Sage
Solution Sage

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 

JoeBarry_0-1695630764793.png

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

View solution in original post

2 REPLIES 2
JoeBarry
Solution Sage
Solution Sage

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 

JoeBarry_0-1695630764793.png

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

Thank you so much @JoeBarry 

It worked 😊

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.