Counting Unique rows in a pivot table

I've googled the issue without any great success. Perhaps someone here can help.
I have a Data Connection and the data is added to the Model, I have then inserted a PIVOT TABLE to display a selection of the data. This all works fine. I'd like a cell above the PIVOT TABLE to contain the number of unique entries in one of the columns (not the count of Values.)

I'm also using a slicer to filter the table and would liek to count to reflect the filtered table

Several formulas I've tried work on the unfiltered data but fail when I apply a filter with the slicer.

... any suggestions.

Thanks

Create a new pivot table adding to the Model, just use the field with unique values to do a distinct count so you will see only the header and the total, then go to Pivot Table Analysis click in the OLAP Tools button, select Convert to Formula.
With this new cube formula go to the header copy the formula and go back to the value cell and substitute the cell reference in it. Now you will have an independent calculation of you Pivot Table unique value.

DJunqueira ...Excellent !!... I never cease to be amazed at what is possible. This was exactly what I was looking for... many thanks

Fantastic solution, DJunqueira! Here is a Rep for you!

Thank you both, happy to help.