How to "hide" lines in a table when a certain value is 0

[Ishragil]

Hi

In the following table, I would like to hide the lines where "Total lines" (which is a calculates measure) equals 0:

I've tried several options, such as  unmarking "Include zero values"

but the lines continue to appear

[Ishragil]

Still didn't find a solution
Any idea?

[MayilVahanan · Accepted solution]

HI @Ishragil 

Reason is still display the zero values, due to "Hours" measure.

If you want to remove the lines, try like below

If("Total lines" expression > 0, Hours expression, 0)

[Ishragil]

It's so simple that I feel the need to smack myself😂

Thanks a lot my friend🌻