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

User_Q7YIK

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

Henry Cabrera

Hello,

There's a concept in data analysis called granularity, which simply refers to the level of detail in fact tables. It seems the error you're reporting is due to one of the tables not having the same level of detail when joining two tables—likely the one containing the column that groups the other rows when added to the report. You should check this level of detail.

I hope it helps.

Regards.

Gianni Ceresa

Extending on what Henry said already, if you don't have a join rule error (check the query generated and you will be fixed), then it's all about granularity.

If that quantity and id is linked to 2 different line numbers, what you see is correct, because you requested to see each line number individually. If that quantity and id isn't connected to the 2 different line numbers, then we are back at the first line: check your join expression because one is wrong and is creating the duplication of rows.

If the quantity and id is connected correctly to the 2 line numbers, than all is good. At that level of details it is correct to see the quantity and line number duplicated. If the line number and quantity exists at an higher level of granularity only, but you want it repeated in case you go to a finer details, but to not count in double when you check the right (or higher) granularity, you can set your content levels accordingly.

User_Q7YIK

I had checked the join and all seems to be joined as correctly , i agree with both of you about granularity just not very sure how to troubleshoot it once i verify the join in the physical layer as well as levels. what do you mean by this part(If the quantity and id is connected correctly to the 2 line numbers) and how can i validate it . Also how can i check if this is correct? —-

If the line number and quantity exists at an higher level of granularity only, but you want it repeated in case you go to a finer details, but to not count in double when you check the right (or higher) granularity, you can set your content levels accordingly.—

Gianni Ceresa

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 :)