TOP N filter not displaying the correct N

[icbd]

Good morning all,

I am trying to display a table of the Top 10 faults for a particular machine on a per week basis.

For some reason it displays a (seemingly) random number of faults and I am unsure why.

Here is a screenshot of the table as it is displayed right now.

This other table is from the exact same data and works correctly:

Any pointers as to why I'm seeing this behaviour would be great.

[Jeanxyz]

@icbd The filtering context of the two visuals are different. In visual 1, you filter in  configstation.id=1, in visual 2, configstation.id=2. Could it be in  Week 2022-07-17, there are only 2 items appearing because they are only two items meeting the condition configstation.id=1? 

[vanessafvg]

its hard to see without seeing what your model looks like.  also place your countid column on the page, that might give you some insight.

[icbd]

It is in the "Amount" column which has been renamed.

[vanessafvg]

what does your data model look like?

[icbd]

I simplified the model quite a bit, unfortunately everything is DirectQuery so I cannot upload a file.

Hope this helps you out in helping me. 

The date table is marked as such. I added a column to it to get the starting day of the week in there (sundays). This is what I am using to sort by week.

So long as I don't use the TOP N filter, everything works as intended.

[vanessafvg]

I think the issue could lie in the fact that you have a many to many to many relationship between date and your table but im not sure without access to some sample data, the issue would almost certainly be in your model in my opinion.    are you placing the date from the date table?  if you swap it for the date in your table does it make any difference?