Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Compare value in the same column

Hi   I have table below :  Name Group Value A 1 20 B 1 20 C  1 20 D  2 20 E  2 24 F  3 12 G  3 12 H 3 12 I  4 12 J  4 20 K 4 24 L 4 ...
Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    pls try this

    Column = 
VAR _Result = CALCULATE(DISTINCTCOUNT('Table'[Value]),ALLEXCEPT('Table','Table'[Group]))
RETURN
IF(_Result=1,"OK","KO")

  • Ahmedx's avatar
    Ahmedx
    2 years ago

    pls try this

    Column = 
VAR _Result = CALCULATE(DISTINCTCOUNT('Table'[Value]),ALLEXCEPT('Table','Table'[Group]))
RETURN
IF(_Result=1,"OK","KO")

  • danextian's avatar
    danextian
    2 years ago

    Hi Anonymous ,

     

    Try this as a calc column:

    Coherence =
IF (
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Value] ),
        ALLEXCEPT ( 'Table', 'Table'[Group] )
    ) > 1,
    "KO",
    "OK"
)

     

danextian's avatar
danextian
Icon for Super User rankSuper User
2 years ago

Hi Anonymous ,

 

Try this as a calc column:

Coherence =
IF (
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Value] ),
        ALLEXCEPT ( 'Table', 'Table'[Group] )
    ) > 1,
    "KO",
    "OK"
)