Power Pivot & Calculated Fields using Distinct Value Count

Hello,

I'm trying to develop a pivot table that uses calculated fields. In the past, I've used a standard pivot to work out option count at the "Product Type" level (or any other level put into the pivot table) and used the count function on the "Brand + Colour for Option Count" column to count distinct values and then inserted a calculated field of "Profit $" / "Distinct Count of Brand + Colour for Option Count" to calculate the Option Productivity, as shown in column E on the Power Pivot tab on the attached example.

It seems excel has changed the ability to count distinct values on a field (in a standard pivot) and that I now need to use Power Pivots to get that data, however I can't work out how to now include the "Option Productivity" calculation in the power pivot.

Is there any way to do this now?!

Thanks,


Lis