Same product referenced in 2 categories in calc table

[X_Man]

Hi,

I have a calculated table built to identify which product falls into which category using multiple criteria and it's working fine. Now I would like to know if there is a possibility to have a product referenced in 2 categories in a unique column. It seems I am facing circular depedencies when trying to do this. Does anyone knows if this is feasible ? If yes, how ? If not, what other option could be used to solve this ? The result is used in a slicer to filter the data depending which category is selected.

Thanks in advance for sharing your experience on this topic.

Note: For those who wants to ask the question, I cannot share screen shots because of the sensitivity of the data.

[X_Man]

ProductName Category
Product01 A
Product02 A
Product03 B
Product04 A & B
Product05 B
Product06 B
Product07 B
Product08 B
Product09 A
Product10 A & B
Product11 A & B
Product12 A
Product13 B
Product14 B
Product15 A
Product16 B
Product17 B
Product18 B
Product19 B
Product20 A

I would like the products belonging to 2 categories to be identified as such, so that it could be part of category A if filtered on this one, but also part of B if filtered as such. I hope this clarifies a bit.

[smpa01]

@X_Man  you can achieve this with a disconnected slicer table and a measure like this

Measure = 
VAR curr =
    SELECTEDVALUE ( slicer[Category] )
RETURN
    CALCULATE (
        MAX ( 'fact'[Category] ),
        FILTER (
            'fact',            
                CONTAINSSTRING ( 'fact'[Category], curr )
        )
    )

[X_Man]

@smpa01  thanks a lot for your response and I like what you suggested that could be helpful for later in the progression to resolve this issue. I believe the main challenge is the fact[category] column, as the definition of the category is made by calculation based on multiple criteria. The issue is how to get the categories values for both A & B listed in same column ? I believe this is what is creating the circular dependencies, because some products are part of both calcs.

[smpa01]

Provide dummy data that is representative of your issue