dummy table, and to introduce a condition so only return subset of rows

[JK-1]

I have created an offshoot dummy table but only want to include a certain subset - say the original table has 20000 rows, I just want to return around 500 that meet a set criteria. Would the table be able to provide for that condition, incorporating SELECTCOLUMNS ? I've tried to play around with the below but can't get it to accept. Streamlined version below. Looking for it to only return those where --- IF 'Table'[Company]="Company4"

DUMMYTABLE = SELECTCOLUMNS(
Table,
"Ref", 'Table'[Reference],
"From", 'Table'[From],
"To", 'Table'[To]
)

[johnt75 · Accepted solution]

You can use

DUMMYTABLE
    = SELECTCOLUMNS (
        FILTER ( Table, 'Table'[Company] = "Company4" ),
        "Ref", 'Table'[Reference],
        "From", 'Table'[From],
        "To", 'Table'[To]
    )

[JK-1]

Perfect. Thank you so much