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)
     
NISH72's avatar
NISH72
Icon for Helper IV rankHelper IV
6 years ago

When I add this formula in the new column it's throwing syntax error. It's not accepting return if function. Thank you

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

NISH72 ,

 

Try with comma:

 

NewColumn =
VAR _result = CALCULATE(COUNT('Table'[Id]), ALLEXCEPT('Table', 'Table'[Id]))
RETURN IF(_result > 1, 1, 0)
  • NISH72's avatar
    NISH72
    Icon for Helper IV rankHelper IV
    6 years ago

    The syntax is correct now but still I am not getting desired results. The new column is showing 0 for all rows. Thank you

    • camargos88's avatar
      camargos88
      Icon for Community Champion rankCommunity Champion
      6 years ago

      NISH72 ,

       

      Did you check the posted photo ? Is that the result ?