Forum Discussion
Filtering data for one column displaying all data for the next column
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
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
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?