Dax Data appears twice

[Sam7]

My data looks like

I want to write a measure to say if my

Invoice number appears in week 1 and 2 then week 1 and 2 ,

Invoice number appears in week 1 and not 2 then week 1 and not 2 

I want to then use this as a slicer. 

Thanks

[sevenhills]

You posted sample data! What is the output you are expecting? 

You are saying you want to use the slicer, which you can drag the invoice number with your data now also. Unless you want a unique list. Then in such cases, you can either do in Power Query a new table and link back or in DAX as new table as Values ('Table'[Invoice Number]) and then use it. I prefer Power Query!

[Sam7]

Hi. thank you for your input. 

I wanted a slicer so they can select the In week 2 and Week 3 OR another option in the slicer would be In Week 2 and Not in Week 3 etc. 

I want to see what has come in during week 2. 

[sevenhills]

Please see these 

Apply AND logic: https://www.youtube.com/watch?v=tONOosN1xAs

                             https://www.sqlbi.com/articles/apply-and-logic-to-multiple-selection-in-dax-slicer/

                             https://www.youtube.com/watch?v=X5T4rIZovHk 

Apply OR logic:    https://www.youtube.com/watch?v=l5JX3G5Ntzk 

Hope this helps!