Power Pivot in Excel shows rows with no data when filtered on column

[PowerPivotinExcel]

Hi, I'm using Office 365.
I have a Power Pivot in Excel's data model. In the data model, I have a fact table named "range" and several tables named Table2, Table3, etc. The tables (other than my fact table) serve only to preserve a particular sort order when I create slicers off these columns. The problem: when I apply a slicer based of columns from these connected tables, the rows in my pivot table show all the filtered out rows and display 0 values for the data. In other words, the data is being filtered out, but the rows are not. How do I fix that?

Here's an example:
In Table2, there is a column for New Price Segment and a column for Sort Order. I mapped New Price Segment in Table2 to New Price Segment in Range. I made a slicer based on New Price Segment in Table2. When I apply the slicer to my pivot table where "product" is in the rows, I'm seeing every product in Range in the rows but data only appears for the items in the selected price segment.

Any help would be so deeply appreciated--this is my first project in Power Pivot! Thank you!

 

[AlanSidman]

It would be very helpful if you attached an actual sample file with data that is representative of your actual data. Make sure that you do not have any personal or confidential data in your sample. Working with sample data makes the steps to a viable solution easier than playing a guessing game as to how your data is set up and formatted.

 

[PowerPivotinExcel]

It would be very helpful if you attached an actual sample file with data that is representative of your actual data. Make sure that you do not have any personal or confidential data in your sample. Working with sample data makes the steps to a viable solution easier than playing a guessing game as to how your data is set up and formatted.

Thank you for your response! I actually found the solution:
I was calculating a % change measure by taking this year/last year and subtracting 1. This was messing things up and causing the value for percent change versus year ago to be -100%, which was making the rows appear. It's strange that this calculation works perfectly in vanilla Excel but doesn't work in Power Pivot, but that's how it is!