I need only the rows of the table with a certain value

[#1]

Hello

Help me, please

I have a table with one dimension and one expression:

1)

2)

the result looks like this:

And now I need only the rows of the table with a certain value = 157.

I add this condition...

and result looks like this:

Help me, please ;((((((((((((((((

[Nicole-Smith]

count({<FieldWithValue={157}>}DISTINCT SYSAGID)

[alexandros17 · Accepted solution]

Write:

If(Count(Distinct SYSAGID)= 157, Count(Distinct SYSAGID), 0)

And in presentation tab verify the default "Suppress zero values"

But if you need values from other fields you must use however aggregated function so:

If(sum(otherfield) = 157, count(distinct SYSAGID), 0)

Hope it helps