Hi all,



I have a table in a data model with sales figures for different models of equipment in one table, this is linked to a calendar table by date. The pivot table displays my results perfectly, including a measure that gives a count of the different used models sold against the sales persons name. However, when I double click on the count, the list does not show the correct results. It's like the count filter from the measure is being ignored, instead it shows me all the results in a table for the selected sales person.



What am I doing wrong? is there a guide out there to this anywhere?



Any help appreciated



The measure I am using:



Please Login or Register  to view this content.