Forum Discussion

Antonio_Gomez's avatar
Antonio_Gomez
Icon for Resolver I rankResolver I
4 years ago
Solved

Difference in rows using merge

The merge indicates "The selecction matches 8758 of 8758 rows from the first table".     But if I count the rows of the first table the number of rows is 8663. Quantity is shown below "Table...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • Antonio_Gomez's avatar
    Antonio_Gomez
    4 years ago

    Hi mussaenda 

     

    I don't know why, but today there is no difference between the screens or rows.

     

    I didn't get a chance to test your solution

     

    Thanks 🙂

mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Antonio_Gomez ,

 

it can happen if the merge is causing some duplicates.

Select the whole table and remove duplicates.

Or.. Group and count to know which are the rows having duplicates.

 

Hope this helps.

 

 

Antonio_Gomez's avatar
Antonio_Gomez
Icon for Resolver I rankResolver I
4 years ago

Hi mussaenda 

 

Thanks for participing. Please, can you help me telling me how do I remove duplicates from this screen ?

 

By the other hand, I'm curious about how to Group and count to know which are the rows having duplicates.

 

I'm still learning PBI and I would like to know some more few tips 🙂

 

 

  • mussaenda's avatar
    mussaenda
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi Antonio_Gomez ,

     

    on your merged table,

    Select the whole table, right click and remove duplicates. 

    Let me know if the number of rows match on your counting.

     

    If not, let's do the second step.

    Hope this helps

     

    • Antonio_Gomez's avatar
      Antonio_Gomez
      Icon for Resolver I rankResolver I
      4 years ago

      Hi mussaenda 

       

      I don't know why, but today there is no difference between the screens or rows.

       

      I didn't get a chance to test your solution

       

      Thanks 🙂