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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Zilver
Regular Visitor

Show only matching values from multiple tables

Hi all,

I have 2 tables like this :

 

Table 1

Ord_NumberStatus
10D
20D
30D

 

Table 2

Ord_NumberStatus
40U
50U

 

and I have Table 3 have so many numbers including some values from table 1 & 2 like this:

 

Table 3

Ord_NumberStatus
10D
15D
20D
45U
50U

 

So what i'm trying to do to show all the data who matched in table 1 and 2 like this:

 

Table 3

Ord_NumberStatus
10D
20D
50U

 

Thanks all

1 ACCEPTED SOLUTION
dax
Community Support
Community Support

Hi @Zilver , 

You could create a table to union table1 and table2 's column, then create relationship between table3, then use not blank in filter, which will work.

Or you also could use measure to achieve this goal(don't create relationship between new table and table 3). You could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
dax
Community Support
Community Support

Hi @Zilver , 

You could create a table to union table1 and table2 's column, then create relationship between table3, then use not blank in filter, which will work.

Or you also could use measure to achieve this goal(don't create relationship between new table and table 3). You could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

Table 3, the last one is common of 1 and 2. But one and two had nothing common.

But refer

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @

Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

So far what I did is I create table 3 and I put table 1&2 in (filter on this page) and I select filter type : basic filtering "select all" for both table. and ofc I create relationship between them as (many to one)(both).

and didn't work 😞

 

please if someone could help me how to fix that I really appreciate it.

What is the logic to achieve this table

Table 3

Ord_NumberStatus
10D
20D
50U

 

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
Anonymous
Not applicable

I do have the same problem. In my specific case I use names instead of numbers. Imagine data since 2019 from my team. In all this team some people left the team. I have a table with EVERYONE since 2019 and another with only the ones that are in the team right now. I want to use my second table to filter he first one so only the values of the second will appear.

So in resume. The first table as thousand of rows and columns. And the second one only has the names that I wat to "filter".

 

 

NamesAgeIDetcetcetc
Mike741325etcetcetc
Freddy261326etcetcetc
Carl997653etcetcetc
Mark341746etcetcetc
John579816etcetcetc
Mary862749etcetcetc
Amitchandak
305472etcetcetc

 

Names

John

Mary
Mark
Amitchandak

 

My final result should look like this

 

NameAgeIDetcetcetc
Mary862749etcetcetc
Mark341746etcetcetc
Amitchandak305472etcetcetc
John579816etcetcetc

 

 

Also , this should be displayed in a bar chart

Hope it helps

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.