Forum Discussion

MaryDay's avatar
MaryDay
Frequent Visitor
7 years ago
Solved

Duplicate column filter

Hello!

 

I have a column with duplicate values. I need to write a DAX code, that will produce 'true' if the value is repeated and 'false' if it is unique.

 

Example:

 

1   false

2   true

2   true

3   false

4   true

4   true

5   false

 

Help me, please.

Need Help
  • tex628's avatar
    tex628
    7 years ago

    I believe all you need to do is add another earlier statement related to the 2nd column.

    Column =
If (
Calculate( Countrows( 'Table' ) ,
    All( 'Table' )
[Column] = Earlier( [Column] ) ,
    [Column2] = Earlier( [Column2] )
) = 1 ,
"False" , 
"True"
)


     

4 Replies

  • tex628's avatar
    tex628
    Community Champion
    7 years ago
    Column =
If (
Calculate( Countrows( 'Table' ) ,
    All( 'Table' )
[Column] = Earlier( [Column] )
) = 1 ,
"False" , 
"True"
)
    • MaryDay's avatar
      MaryDay
      Frequent Visitor
      7 years ago

      It's perfect, thank you very much!

      Maybe you know, how to do it, if I have 2 conditions? that is, I need to select values that are duplicated in both the first and second columns at the same time.

       

      Example:

       

      1    a    false

      2    b    true

      2    b    true

      3    a    false

      4    c    false

      4    b    false

      5    d    true

      5    d    true

      • tex628's avatar
        tex628
        Community Champion
        7 years ago

        I believe all you need to do is add another earlier statement related to the 2nd column.

        Column =
If (
Calculate( Countrows( 'Table' ) ,
        All( 'Table' )
[Column] = Earlier( [Column] ) ,
        [Column2] = Earlier( [Column2] )
) = 1 ,
"False" , 
"True"
)