Count distinct values based on items NOT SELECTED in slicer

[dmswimtrk2]

I've officially run into a loop with Chat GPT on this issue!

I am trying to create a matrix visual in PowerBI that counts the distinct IDs based on age grouping for values that ARE NOT SELECTED in a filter. 

Here is an example of my table:

Here is an example of the output:

The closest I've gotten is using this formula:

DistinctIDs_NotSelected = CALCULATE( DISTINCTCOUNT(Data_Labels[id]), NOT(Data_Labels[PRODUCT CURRENT USE] IN VALUES(Data_Labels[PRODUCT CURRENT USE])) )

HOWEVER, the problem with this formula is that it doesn't recognize IDs that do have a product selected, but have other products associated with it. Using the example table above and assuming my slicer has Product 1 selected, this formula will count id #4 in both the selected and not selected counts because PowerBI doesn't know that rows 3 in 4 in the example table are associated with row 2. How do I adjust the formula or create a new column so that it searches the table for an id and assigns all rows of the id to true if the slicer shows the selected product (and false if it doesn't)?

[amitchandak]

@dmswimtrk2 , You need slicer on  independent/disconnected table

Need of an Independent Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE