Forum Discussion

kevlin79's avatar
kevlin79
Regular Visitor
7 years ago
Solved

Find irregular pairs

I have a data setup where row values in two columns are expected to match but want to identify instances where there is an "irregularity". So in the following table: "1 - Joe" is such a case since th...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    kevlin79

     

    My apologies.I had to go out after my previous post

    Try this Column in this situation.

    File attached as fell

     

    Column 2 =
VAR DistinctCount_Identifiers =
    CALCULATE (
        DISTINCTCOUNT ( Table1[Identifier] ),
        ALLEXCEPT ( Table1, Table1[Name] )
    )
VAR Count_Identifiers =
    CALCULATE ( COUNT ( Table1[Identifier] ), ALLEXCEPT ( Table1, Table1[Name] ) )
RETURN
    IF (
        AND (
            DistinctCount_Identifiers > 1,
            DistinctCount_Identifiers <> Count_Identifiers
        ),
        "I am Irregular"
    )

     

kevlin79's avatar
kevlin79
Regular Visitor
7 years ago

Zubair_Muhammad 

 

Seems to work! If I also wanted the pair "2 - Joe" to be marked as part of the irregulars, how would the code be adjusted to this?

 

Super thanks