I am trying to show only those values which are greater than equal to 100000 and less than equal to -100000 using following measure: if((Column(4) + Column(3) - Column(2)) >=100000 or (Column(4) + Column(3) - Column(2)) <= -100000, (Column(4) + Column(3) - Column(2)),Null()) Above mentioned measure is calculating based on other columns in Table Report. Getting following result even after checking Suppress Zero Values and Suppress Missing from Presentation tab and from Dimension tab Suppress when value is null for all dimensions.
If above scenario doesn't we can also show values based on one dimension "CLAIMID".
This approach won't work because, presumably, columns 2, 3, and 4 have non-null / non-zero values. If you remove those columns entirely and replace the column references with the underlying formulas, you should be able to use suppress zero / null. Otherwise, you could try using Dimension Limits settings, but this would require that this column be first in the measure order.