topic Re: Filter Dimension wrt Measure in App Development

Filter Dimension wrt Measure

Wed, 27 Apr 2016 09:39:48 GMT

Hi,

I have a bar chart where one dimension and two measures available. For some values or selection one of the measure value going 0 or zero but I don't want to show those set of bars where one of the two measure value is 0.

i want to remove those values on axis which contains 0 value by default or after selection.

I am attaching two snapshots which cal clarify both cases stated above.

Re: Filter Dimension wrt Measure

sunny_talwar — Wed, 27 Apr 2016 15:58:36 GMT

May be something like this:

Change Expression1 to this -> If(RangeMin(Expression1, Expression2) > 0, Expression1)

Change Expression2 to this -> If(RangeMin(Expression1, Expression2) > 0, Expression2)

Re: Filter Dimension wrt Measure

Fri, 29 Apr 2016 06:27:23 GMT

Hi Sunny,

Thanks for your comment, yes its working almost fine , Just one concern left that , measure are perfectly filtering but the dimension values who has null measure also coming on the axis . Can you please help me in this

Re: Filter Dimension wrt Measure

sunny_talwar — Fri, 29 Apr 2016 17:14:48 GMT

Have you checked 'Suppress When Value is Null' on the dimension tab? If not do that and null dimensions should be removed.