can we hide entire row where expression value is null in a straight table

[vish123]

Hi Team,

I have a list of columns where we have expression as a column as well in a straight table. some of this expression value is nulls. How can i hide these rows where this expression gives null values.

[Or]

You can't directly hide a row just because one (of several) expressions is null, as far as I know.

You can either use the same calculation to nullify all of the other expressions using an if() condition, e.g. if the null expression is Only(FieldName) then your other expressions might be:

Sum(Sales)*if(IsNull(Only(FieldName)),null(),1)

Or you could nullify one of your dimensions and then use "Hide null values" on that dimension.