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: Worklogs (8,663 rows)...."

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 🙂

Difference in rows using merge | Microsoft Fabric Community

amitchandak
Super User
4 years ago
Antonio_Gomez , Is there any data filtering happening in that table in power query before the data is used for visualization?
Antonio_Gomez
Resolver I
4 years ago
Hi amitchandak

Thanks for the response and attention. But, I don't have any filter in any table
mussaenda
Community 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
  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
    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