How to supress zero measure values inside aggr function

[abe786]

I have below sample table

Dim, Value

A, 1

A, -1

B, 2

C, 3

We are displaying this information in Qlik Sense UI Table with sum(Value) as a measure. Also we're supressing rows where sum(Value) comes as zero. So row with Dim as A would be supressed. 

Now User also wants the count of rows which are being displayed in this table in sheet title. The correct result here, would be 2 .

If I derive this count using expression count(aggr(sum(Value), Dim)) it comes up as 3 since it counts the row with dim A.

How can I supress 0 measure row inside aggr or if there is any other possible solution to this requirement, let me know? I 

[rubenmarin · Accepted solution]

Hi, maybe calculating this as: sum(aggr(If(sum(Value)<>0,1), Dim))