condintional indexing or removing row matching a filter

[Ratax]

Hello all

i need help with a project

I have made heavy editing to my table, which have left a lot of rows with no infomation. It messes with my indexing.

So i need help with condintional indexing or to remove rows that meet certain criteria

My table looks like this:

What is need is either condintional indexing (the column E):

or to remove the rows with errorCode = 0 and StickId = 0

i Hope someone can help 🙂

[v-yuezhe-msft · Accepted solution]

@Ratax,

I create a table(Table2) using the above sample data, then create a calculated column in the Table2.

Column = Table2[StickID]+Table2[ErrorCode]

Create a new table using DAX below.

Table = CALCULATETABLE(Table2,Table2[Column]>0)

Regards,
Lydia