Forum Discussion

Kareus's avatar
Kareus
Helper I
2 years ago
Solved

Need Help: Filter Column Question

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 # f...
  • Daniel29195's avatar
    2 years ago

    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! 🤠