Compare value in the same column

[Anonymous]

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	12
M	4	12
N	4	12

I would like to compare the value in the same group, all the values in the same group must be identical == > OK, If not KO 

The result is as below : 

Name	Group	Value	Coherence
A	1	20	OK
B	1	20	OK
C	1	20	OK
D	2	20	KO
E	2	24	KO
F	3	12	OK
G	3	12	OK
H	3	12	OK
I	4	12	KO
J	4	20	KO
K	4	24	KO
L	4	12	KO
M	4	12	KO
N	4	12	KO

thank oyu in advance for your help

[Ahmedx · Accepted solution]

pls try this

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

[Ahmedx · Accepted solution]

pls try this

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

[danextian · Accepted solution]

Hi @Anonymous ,

Try this as a calc column:

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

[Ahmedx · Accepted solution]

pls try this

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

[Ahmedx · Accepted solution]

pls try this

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