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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.