If condition with Aggr in KPI

[AdithyaVarma8]

How to get the below expression in KPI

If(sum( Aggr (CustomerId, Dispense)) = 0, Count(Distinct CustomerId),0). 

The same expression works fine in the table below.  Ideally the result of KPI should be 6 as per the below  highlighted scenario.

=Aggr(SUM(Dispense), CustomerId)	sum( Total <CustomerName,CustomerId> Dispense)	If(sum( Aggr (CustomerId, Dispense)) = 0, Count(Distinct CustomerId),0)	=If(Aggr(SUM(Dispense), CustomerId)=0,CustomerId)	=Aggr(SUM(Dispense), CustomerId)
0	0.0E+000	1	12	0
0	0.0E+000	1	13	0
0	0.0E+000	1	14	0
0	0.0E+000	1	15	0
0	0.0E+000	1	16	0
0	0.0E+000	1	17	0

[Lisa_P]

Try using set analysis for your KPI:

Count({<Dispense={">0"}>}Distinct CustomerId)

[Channa · Accepted solution]

Count(Distinct {<CustomerId={"=Aggr(SUM(Dispense), CustomerId)>0"}>} CustomerId)

[AdithyaVarma8]

@Channa  Thank you.