Forum Discussion

siva54's avatar
siva54
Helper I
4 years ago
Solved

Creating a calculated column

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 ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    siva54 , Try like

     


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

amitchandak's avatar
amitchandak
Super User
4 years ago

siva54 , Try like

 


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

  • siva54's avatar
    siva54
    Helper I
    4 years ago

    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 .