Power Pivot Table Refresh Issue

[Wayne K]

Hi and thanks for having this forum to discuss issues with Excel/VBA.

1) I have created a macro to take raw data and make a Table and several Power Pivot Tables to show "Count of Disputes" and use those values on another sheet and it works great.

Disputes(PivotTable14)
Location	All
Fiscal Year Raised	All
Current Workflow Stage	Dispute
	Column Labels
	FALSE	TRUE	Grand Total
Count of Location	10​	1​	11​

2) I then created another Macro to select a "Location" in the Table and delete the rows in the Table that are not from that Location, REFRESH the data and get the values of Disputes from the refreshed Power Pivot Table. However, if there are no "Disputes" in the selected "Location", the refreshed Power Pivot Table doesn't have "DISPUTE" in the "Current Workflow Stage" filter and then shows ALL the values of 703 instead of showing "0" disputes.

Disputes(PivotTable14)
Location	All
Fiscal Year Raised	All
Current Workflow Stage	All
	Column Labels
	FALSE	TRUE
Count of Location	703​	20​

3) How do I show "0" "Disputes" in the Power Pivot Table when there are no "Disputes" in the "Current Workflow Stage" filter which then only shows all the values at 703 instead of "0".

Would it be the way I set up the original Power Pivot Table or is it something else.
Any help would be appreciated.
Thanks.
Wayne