Need Help: Filter Column Question

[Kareus]

How can I DAX code this.

The 1st column is a unique list of part #

The 2nd column in a complete global list of item #

I would like to make a 3rd column that shows (complete global list of item # filtering out the part #)

Seems like this would be pretty easy to do but I'm struggling.

[Daniel29195 · Accepted solution]

@Kareus 

if you are aiming at creating a new calculated table showing the gloabl list of items filtering out the list of parts : 

caluclated table = 

except ( all(tbl[item_col_name]) ,  all(tbl[parts_col_name]))

let me know if this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[Kareus]

I can make that work.  Thank you!