topic dummy table, and to introduce a condition so only return subset of rows in DAX Commands and Tips

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

JK-1 — Fri, 13 Jun 2025 13:23:07 GMT

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]
)

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

johnt75 — Fri, 13 Jun 2025 13:33:56 GMT

You can use

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

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

JK-1 — Fri, 13 Jun 2025 14:59:58 GMT

Perfect. Thank you so much