Consider only dimension elements for which a KPI condition applies.

[Zeta]

Given a table with two columns as follows:

Person | Number of candy
1 | 1
2 | 1
1 | 1
3 | 1
3 | 1
1 | 1
1 | 1
3 | 1
3 | 1
3 | 1
3 | 1

The total number of candy per person should be displayed in a table chart.

=> Column 1 | Column 2
Dimension[Person] | sum(Number of candy)
1 | 4
2 | 1
3 | 5

How can I add the following condition to the table chart:
Show only all people with sum(Number of candy) > 1
=> Column 1 | Column 2
Dimension[Person] | sum(Number of candy)
1 | 4
3 | 5

Question 2:
What does the formula in the KPI chart look like if I want to show how many people ate more than one candy?
In the above case, the result should be 2.

Thx for help

[Chanty4u · Accepted solution]

Try this 

Count(

  Distinct

  {<

    Person = {"=Sum([Number of candy]) > 1"}

  >} Pers

on

)