Forum Discussion

rifaymars's avatar
rifaymars
Helper I
1 year ago
Solved

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

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 a...
  • Anonymous's avatar
    Anonymous
    1 year ago

    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