Question to filter usage in Power BI

[luftpolster]

Hi,

I'm trying to filter the duplicates in the column "TYPE" to show the ones which are having the "NR" of 2 and another number.

In this example that would be the lines 2,3 and 4,5 because the lines are duplicates in the TYPE column and have the NR "2" and one or more other numbers in the NR column.

Does anyone know how I could filter this in Power BI?

LINE	TYPE	NR
1	A	1
2	B	2
3	B	1
4	C	2
5	C	3
6	A	3

 

[JGordon11]

let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    ChangeType = Table.TransformColumnTypes(Source,{{"LINE", Int64.Type}, {"TYPE", type text}, {"NR", Int64.Type}}),
    GroupRows = Table.Group(ChangeType, {"TYPE"}, {{"tbl", each _, type table [LINE=nullable number, TYPE=nullable text, NR=nullable number]}}),
    AddConditionalColumn = Table.AddColumn(GroupRows, "Custom", each if 
        List.Contains([tbl][NR],2) and [tbl][NR] <> List.Repeat({2},List.Count([tbl][NR])) then 1 else 0),
    FilterRows = Table.SelectRows(AddConditionalColumn, each ([Custom] = 1)),
    ExpandNR = Table.ExpandTableColumn(FilterRows, "tbl", {"LINE", "NR"}, {"LINE", "NR"}),
    ReorderColumns =  Table.RemoveColumns(Table.ReorderColumns(ExpandNR,{"LINE", "TYPE", "NR"}),{"Custom"})
in
    ReorderColumns