Why am i getting repeating metrics when i add line number to my report

Question

I have an rpd whose fact table is based on flattened dimensions, in the physical layer the source dimetions together with other tables are joined to fact creating a start schema. Issue is when i create report my metrics are repeated  and it seems  like whenever i add  one specific column my metrics getting repeated in multiple rows. My expected resuts are the two numbers highlighted in red and the corresponding quantity of 1

Screenshot 2026-02-18 161430.png

Gianni Ceresa · Answer

i cant replicate in the database

You have the logs, those give you the SQL query generated, therefore you must be able to reproduce it in the database.

There isn't much more that can be said: you have the data, you have the model, you have the generated query. That's all you need to explain why you see what you are seeing. Here in the forum we have nothing of all that, therefore can't do anything more than guessing…

User_Q7YIK · Answer

i have tried to investigate this part @Gianni Ceresa

Because for a given "P Number" there are many "Line Number" and those seem to join many times to "Quantity" and "Id", you should investigate the "Line Number" mostly I would say: why are you seeing many instead of just the 2 you expected? And if it's correct to see many, why are they all connecting to Quantity and Id instead of just your 10 and 20 to have that join) but cant seem  to find why its behaving like that, in the source- i can see my expected results- the two rows and except for i cant see the amount since those are from another table and i cant replicate in the database. any other line of thought you can recommend

Gianni Ceresa · Answer

In your picture, for one "P Number" you have many "Line Number" (7 in your picture).

You seem to be saying that your expectation was to see only 2 "Line Number", values 10 and 20, and "Line Number" 10 should have a "Quantity" = 1 and "Id" = …R00814, while "Line Number" 20 should have "Quantity" = 1 and "Id" = …R02981.

All those other "Line Number" you are seeing, come from somewhere. You maybe forgot a filter somewhere on a status of the Line Number, or to only take the most recent Line Number or the first one or something like that.

What you see on your screen comes from the join conditions you defined. It isn't wrong, it works exactly as designed in your model.

You now need to look further into your data to find out if you didn't forget a filter somewhere, maybe in a logical table source to not see multiple versions of something. Or maybe you are forgetting such a filter in the analysis you built.

Because for a given "P Number" there are many "Line Number" and those seem to join many times to "Quantity" and "Id", you should investigate the "Line Number" mostly I would say: why are you seeing many instead of just the 2 you expected? And if it's correct to see many, why are they all connecting to Quantity and Id instead of just your 10 and 20 to have that join?

Can't really say much more as here we only saw a picture with 4 columns and 7 rows and no idea of what is behind that :)