Filter list

[lylx]

I have table in power bi:

Name	Done	Not done
John	Max
Max	Richy
Richy	Christin
Christin
Arya
Robb

I want to result:

Not done

John

Arya

Robb

Please help me!

[Zubair_Muhammad · Accepted solution]

@lylx 

One way is to  create a new Query From the Query Editor as follows

List.RemoveMatchingItems(YourTable[Name],YourTable[Done])

Also we can create a calculated table with DAX
from the modelling tab>>new Table

CalculatedTable = Except(VALUES(YourTable[Name]),VALUES(YourTable[Done]))

See file attached with these options

[lylx]

Thank you so much!