Calculated dimension

[MTA]

Hello,

I have an tabel object with multiple dimensions and measures. I have a measure calculated like maxstring(field).
But when I filter on some field it becomes '-' for some rows.
I would like to suppress those rows, but I know that null values can only be suppressed in dimensions, not measures.
So I tried to make an calculated dimension like
If(isnull(maxstring(field)), null, 1) so I can filter with it the null values, but I gen the invalid dimension error.

Any ideas?
Thank you

[Anil_Babu_Samineni · Accepted solution]

Perhaps this

If(isnull(Aggr(maxstring(field), field)), null(), 1)

[MTA]

Works like a charm! Thank you! 

[MTA]

Also, any idea if I can hide the column and still keep the calculation?

I tried to hide it with an show if condition, but if it is not visible it won't make the calculation. 

[Anil_Babu_Samineni]

On what condition and scenario you want to hide the column?

[MTA]

I would like for it to not be seen at all in the script, and just to be something created so I could eliminate null values.