Forum Discussion
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 | 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
pls try this
Column = VAR _Result = CALCULATE(DISTINCTCOUNT('Table'[Value]),ALLEXCEPT('Table','Table'[Group])) RETURN IF(_Result=1,"OK","KO")pls try this
Column = VAR _Result = CALCULATE(DISTINCTCOUNT('Table'[Value]),ALLEXCEPT('Table','Table'[Group])) RETURN IF(_Result=1,"OK","KO")Hi Anonymous ,
Try this as a calc column:
Coherence = IF ( CALCULATE ( DISTINCTCOUNT ( 'Table'[Value] ), ALLEXCEPT ( 'Table', 'Table'[Group] ) ) > 1, "KO", "OK" )
3 Replies
pls try this
Column = VAR _Result = CALCULATE(DISTINCTCOUNT('Table'[Value]),ALLEXCEPT('Table','Table'[Group])) RETURN IF(_Result=1,"OK","KO")Hi Anonymous ,
Try this as a calc column:
Coherence = IF ( CALCULATE ( DISTINCTCOUNT ( 'Table'[Value] ), ALLEXCEPT ( 'Table', 'Table'[Group] ) ) > 1, "KO", "OK" )pls try this
Column = VAR _Result = CALCULATE(DISTINCTCOUNT('Table'[Value]),ALLEXCEPT('Table','Table'[Group])) RETURN IF(_Result=1,"OK","KO")