Forum Discussion

icbd's avatar
icbd
Icon for Helper I rankHelper I
4 years ago

TOP N filter not displaying the correct N

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 ...
Need Help
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
4 years ago

what does your data model look like?

icbd's avatar
icbd
Icon for Helper I rankHelper I
4 years ago

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's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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?