Solved: Re: Create a new table from a column filter

Syndicate_Admin · ‎03-27-2021

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 · ‎03-27-2021

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.

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

View solution in original post

CNENFRNL · ‎03-27-2021

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.

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

Create a new table from a column filter

Helpful resources

Fabric Data Days

Power BI Monthly Update - October 2025

FabCon Atlanta 2026

How to Get Your Question Answered Quickly

Fabric Data Days starts November 4th!