Forum Discussion

NISH72's avatar
NISH72
Icon for Helper IV rankHelper IV
6 years ago
Solved

Conditional calculated column

Hi all I have the following table Id.     Name 1.       A 1.        B 2.        C 3.        D 4.        E   If a particular Id has multiple names attached to it.( For eg id 1 has two names at...
Need Help
Show and Tell
  • camargos88's avatar
    camargos88
    6 years ago

    Hi NISH72 ,

     

    Try this code for a new column:

    NewColumn =
    VAR _result = CALCULATE(COUNT('Table'[Id]); ALLEXCEPT('Table'; 'Table'[Id]))
    RETURN IF(_result > 1; 1; 0)
     
camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

Hi NISH72 ,

 

Try this code for a new column:

NewColumn =
VAR _result = CALCULATE(COUNT('Table'[Id]); ALLEXCEPT('Table'; 'Table'[Id]))
RETURN IF(_result > 1; 1; 0)
 
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Please try this expression for your column

 

Duplicates = var currentid = 'ID'[Id]
var countthisid = COUNTROWS(Filter('ID', 'ID'[Id]=currentid))
return if(countthisid>1,1,0)
 

If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat