Filtering data for one column displaying all data for the next column

[rifaymars]

Hello guys,

I have this example table. I want to have a slicer to filter Part_Number. But i want in the result in Table visual to have all Document_No that consist this Part_Number, but as well as all othe  Part_Number wich are within this documents.

Document_No	Part_Number
TP-3601	4010101015
TP-3601	4010203007
TP-3601	4010203008
TP-3602	4010101015
TP-3602	4010203009
TP-3602	4010203008
TP-3603	4010203007
TP-3603	4010203008

Example:

In slicer I choose 4010203008. I want the data in Table Visual to be like:

Document_No	Part_Number
TP-3601	4010101015
TP-3601	4010203007
TP-3601	4010203008
TP-3603	4010203007
TP-3603	4010203008

I have tried CHAT GPT, bot no success.

Thnaks!

[v-yangliu-msft · Accepted solution]

Thanks for the reply from Kedar_Pande , please allow me to provide another insight: 
Hi  @rifaymars ,

Here are the steps you can follow：

1. Create a table of dates with no joins to act as a slicer.

Table 2 =
DISTINCT('Table'[Part_Number])

2. Create measure.

Flag =
var _select=SELECTEDVALUE('Table 2'[Part_Number])
var _test=CONCATENATEX(FILTER(ALLSELECTED('Table'),[Part_Number]=_select),[Document_No],"-")
return
IF(
    CONTAINSSTRING(
        _test,MAX('Table'[Document_No]))=TRUE(),1,0)

3. Place [Flag]in Filters, set is=1, apply filter.

4. Result:

As far as I know, [Document_No] has 4010203008 in TP-3601, TP-3602,TP-3603, so they all display

Best Regards,

Liu Yang

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

[rifaymars]

This is exacly what i wanted. Thnaks!

[Kedar_Pande]

@rifaymars 

Create a Calculated Table:

FilteredTable =
VAR SelectedParts = VALUES('YourTable'[Part_Number])
VAR RelatedDocs = 
CALCULATETABLE(
VALUES('YourTable'[Document_No]),
'YourTable'[Part_Number] IN SelectedParts
)
RETURN
FILTER(
'YourTable',
'YourTable'[Document_No] IN RelatedDocs
)

💌 If this helped, a Kudos 👍 or Solution mark ✅ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[rifaymars]

I have tried  this but no success. What should I put in Slicer - Part_Number from the new table (FilteredTable )? And what should I put in Table View?