Forum Discussion

Antonio_Gomez's avatar
Antonio_Gomez
Resolver 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 🙂

Antonio_Gomez's avatar
Antonio_Gomez
Resolver 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
Community 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
    Resolver 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 🙂