Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Remove rows from a Join Table

Dear community, I'm trying to figure out how to exclude the rows for a specific ID, in a column of a Join table. The table has this code: Spot_FW = UNION( SELECTCOLUMNS(UDM_DMO_FORWARD_VALOR,"ID...
  • dedelman_clng's avatar
    dedelman_clng
    5 years ago

    Hi Anonymous - you can use FILTER on the output of SELECTCOLUMNS to remove rows prior to the UNION happening.

     

    FILTER ( SELECTCOLUMNS (...), [Filter Condition] )

     

    You could also potentially use FILTER inside SELECTCOLUMNS by first filtering the base table, then choosing the columns

     

    SELECTCOLUMNS ( FILTER ( [Table], [Filter Condition] ), ... )

     

    Hope this helps

    David

  • dedelman_clng's avatar
    dedelman_clng
    5 years ago

    FILTER( TableName, NOT(TableName[ID_FW] IN {"xx", "yy", "zz"} ) ) 

     

    should work (obviously if the IDs are numbers, don't need the quotes).  If it isn't please share your error message or what behavior you are seeing.

     

    Hope this helps,

    David

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks dedelman_clng! It worked. I tryied Filter function before, but it was not properly written in the DAX code. 

Cheers!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi dedelman_clng! Hope you're fine.

    One more question if you can help:

    Instead of one ID that I need to filter, I need 2 or more ID to be out of the table, what do you think will be the best option? 

    I've tryed NOT [ID_FW] {xx,yy,zz}, but it didn't work.

    Any tip on this?

     

    Thanks in advance

     

    Regards