Forum Discussion

karinafreitass's avatar
karinafreitass
Helper III
5 years ago

Check Duplicates Values

Hi guys,

I have a table called "flancamento" and I would like to find duplicate rows.

I thought of a solution that would return duplicate values ​​in a new column.

Then I am creating a calculated column  and I am using the following function, but maybe I need to add more parameters:

Duplicados = IF(
                      COUNTROWS(
                               FILTER(fLancamento,fLancamento[Lançamento]=
                                         EARLIER(fLancamento[Lançamento])))>1,1,BLANK()

)

 

 

How could I achieve this result?

 

Thanks,

Karina

 

 

Need Help

4 Replies

  • CNENFRNL's avatar
    CNENFRNL
    Community Champion
    5 years ago

    Hi, karinafreitass , you might want to try this measure in a calculated column

     

    RESULT = IF ( CALCULATE ( COUNTROWS ( flancamento ), ALL ( flancamento[Index] ) ) > 1, "Duplicated" )

     

     flancamento[Index] is the first column in your dataset with cardinal numbers 1, 2, 3 ...

    • karinafreitass's avatar
      karinafreitass
      Helper III
      5 years ago

      @CNENFRNL

      @amitchandak

      Thanks for help.

      I've identified a problem. In the visual (table) I identified that the power Bi is generating duplicity as 1 record only and is making the sum of the values. So there's not going to be duplicate values, and that's not cool.

      I need to identify if there are duplicate records in the entire row

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    karinafreitass , Your formula seems fine. Hope you are creating a new column.

     

    You can have new column like

    if( countx(filter(fLancamento,fLancamento[Lançamento] =EARLIER(fLancamento[Lançamento])),fLancamento[Lançamento]) >1 , 1, blank())

     

    New measure like

    if( countx(filter(allselected(fLancamento),fLancamento[Lançamento] =EARLIER(fLancamento[Lançamento])),fLancamento[Lançamento]) >1 , 1, blank())

     

    Please provide your feedback comments and advice for new videos
    Tutorial Series Dax Vs SQL Direct Query PBI Tips
    Appreciate your Kudos.