cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper V

## 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

3 ACCEPTED SOLUTIONS
Super User

pls try this

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

Super User

pls try this

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

Super User

Hi @vnqt ,

Try this as a calc column:

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

Proud to be a Super User!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
3 REPLIES 3
Super User

Hi @vnqt ,

Try this as a calc column:

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

Proud to be a Super User!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Super User

pls try this

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

Super User

pls try this

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.