Create a new table from an Existing table with filter condtion in

To create a new table with filter condition like SQL using where clause. Here we can use CALCULATETABLE and Summarize function.

Steps :

1. Go to Power bi desktop version
2. Go to modelling
3. New Table
4. Put below formulas

New_Table_name = CALCULATETABLE (
SUMMARIZE 
(
'Old_Table',
'Old_Table'[Col1],
'Old_Table'[Col2],
'Old_Table'[Col3],
'Old_Table'[Col4],Old_Table[Col5],
),
'Old_Table'[ID]=1
)