Create a new table from a column filter

[Syndicate_Admin]

Hello
I have a calculated column in my table created by this code:

FilterCol = IF(LEN(Assemk[SERIE])=8 &&

IZQUIERDA(Assemk[TRA],1)="F" &&

Assemk[SUC]="CB" &&

Assemk[DATE]. [Date] > TODAY()-5,

Assemk[SUCCOD],"false")

With this calculated column I can filter all rows that are different from "false" and get only the rows I want. I would like to create a new separate table with only those rows other than "false". How can I do this?

[CNENFRNL · Accepted solution]

You might want to try,

Filtered Table = CALCUALTABLE ( Assemk, Assemk[FilterCol] <> False )

To some extent, such a calculated table is not that necessary as you may use CALCUALTABLE ( Assemk, Assemk[FilterCol] <> False ) as filter modifier in most DAX measures.