Dax code for deleting rows.

[Anonymous]

Hi all,

My first post, so if any suggestions please let me know.

I got a column with client names, I want to delete some rows with a specific name; all names with a suspense account in it. I got a list with these names I want to delete, just don't know how. Any suggestions?

Thanks,

Paul 

[Mariusz · Accepted solution]

Hi @Anonymous 

You can not use DAX to delete rows, but you can exclude them as in the example below.

Measure = 
CALCULATE(
    SUM( 'Table'[Value] ),
    KEEPFILTERS(
        'Table'[ID] IN { "A", "D" } = FALSE
    )
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.