I want to create new table based on distinct element of column?

[maqsud]

I have categorical column imported in Powerbi Desktop and want to create new table based condition:

**Distinct count of Column[Element]>=2**.

Column

A

A

B

C

A

B

Required Table

New Column

A

B

[amitchandak · Accepted solution]

@maqsud ,

Try like

filter(summarize(Table, Table[Column], "_Cnt", count(Table[Column])),[_Cnt]>=2)