Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.