Creating a calculated column

[siva54]

Hi Team

I'm new to power bi, need help to get the Result column.

Here the requirement is, Multiple Porducts can associated with only single Category.
For Example, {A=Fan,Pen}. Here Fan amd Pen is only for Category A. and they should not be used for Other categories
       if Fan or pen used for Other categoreis then the result is "No".

Find the below picture for your reference.

Regards,

siva54

[amitchandak · Accepted solution]

@siva54 , Try like

new column =
var _1= calculate(distinctCOUNT([CATEGORY]), filter(Table, [product] = earlier([product])))
return
if(_1 >1 , "No", "Yes")

[siva54]

Hi @amitchandak  Thanks for the solution. Need analyse cocd level also.

 Here dax is 
var _1= calculate(distinctCOUNT([CATEGORY]), filter(Table, [product] = earlier([product])))
return
if(_1 >1 , "No", "Yes")

in that need to filter out with Cocd .