See if product is in more than one category

[Isa-TheHague]

Hi,

I'm working on a analysis and my dataset consist of to ID columns: [Product_ID] & [Category_ID]

I want to find out what products have records of more than one category.

Example with the desired output [Check multiple categories]:

Product_ID	Category_ID	Check multiple categories
001	001	False
002	001	True
002	002	True
003	001	False
003	001	False

In this example we have 2 Categories, 3 products. Product 2 is in the dataset with both categories. How can I identify the records that have more than one category?

I've been trying this solution and my own variation's of it. It doesn't seem to work. The dataset consists of 44K rows.

Can you please help me figure out a way to do this?

Thanks, Isa

[parry2k · Accepted solution]

@Isa-TheHague try this DAX expression

Column = 
VAR __c = CALCULATE ( DISTINCTCOUNT ( dup[Category_ID] ), ALLEXCEPT ( dup, dup[Product_ID] ) )
RETURN
__c > 1

[Kushagra05]

I am also working on something similar, I am able to create a flag using provided solutions. But I want it as a slicer( if I try to use the calculate measure as a slicer it's not working to filter out same product present in differnt category) . How to use slicer for the same problem ?can anyone help me with the solution 

[amitchandak · Accepted solution]

@Isa-TheHague , create a new column like

new column= calculate( distinctcount(Table[Category_ID ]) ,filter(Table, [Product_ID] = earlier([Product_ID]) ) )

[Isa-TheHague]

Thanks! This also works and gives back the number categories product is in. Actually both your and @parry2k  solution's combined give me great insights in my data.

[parry2k · Accepted solution]

@Isa-TheHague try this DAX expression

Column = 
VAR __c = CALCULATE ( DISTINCTCOUNT ( dup[Category_ID] ), ALLEXCEPT ( dup, dup[Product_ID] ) )
RETURN
__c > 1

[Isa-TheHague]

It worked, Hero!!