Forum Discussion

olimilo's avatar
olimilo
Post Prodigy
8 years ago
Solved

Removing rows based on 1++ criteria

I'm doing this manually on the Excel source file, but I think it could be done natively on Power BI. I looked at the example here but it seems to just select a subset of the data based on the conditi...
Need Help
  • MattAllington's avatar
    MattAllington
    8 years ago

    Just add a custom column as follows (case sensitive)

     

    = if [Client] = “Client A” and [Type] = “Type 3” then “remove” else null

     

    then put a filter on the new colum to remove the results. 

MattAllington's avatar
MattAllington
Community Champion
8 years ago

Just add a custom column as follows (case sensitive)

 

= if [Client] = “Client A” and [Type] = “Type 3” then “remove” else null

 

then put a filter on the new colum to remove the results. 

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    olimilo

     

    Also you can create a new Calculated Table using DAX that filters such rows

     

    Go to Modelling Tab >>New Table

     

    New Table =
EXCEPT (
    TableName,
    FILTER (
        TableName,
        TableName[Type] = "Type 3"
            && TableName[Client] = "Client C"
    )
)
  • olimilo's avatar
    olimilo
    Post Prodigy
    8 years ago

    Thanks! I just remembered a SWITCH statement could be used here as well, and would require lesser indentations code-wise.