Field won’t recount when filtering

I have created a new field to count distinct Product Owners. It shows correctly, but it still show the total count when filtering.

I have used following formula:
=UniqueCount(Applications Master Data:Application Business Owner)

I have added the field to a KPI in a group

Total count Product Owner = 3
Filter on Product A should give Total count Product Owner = 2

How can solve this?

Do I have to adjust the formula, properties or other?

Frode,

Instead of using the Unique Count formula, you'd could do the following:

1. Create a Count column (="1")

This way when you filter on product A it will show 1 for each record and add up to 2 and if you look at the total row count it would show 3.  

If you wanted to do Product count to get 2 (since there are only two records) you could do the following:

2. Create a Repeats column:  Do a SumIf(Product,Product,Count)

3. Create a Total count column.  Total count = Count/Repeats

Cheers,

Ryan

Excellent guide, thanks so much and I appreciate the approach!

Thank you. I appreciate your input.

Br.
Frode