Show Dimension only if all measures greater than x

[mgranillo]

I'm making a table with about ten measures.  I only want to show the dimension if each of the ten measures are > 25. 

How can i do this?

[Anil_Babu_Samineni]

If it includes dimension in calc. Or in script

If(dimension >25, dimension)

And if measures, you can try ti degrade the analysis

Field = {'>25'}

[sunny_talwar · Accepted solution]

May be this

If(RangeMin(Column(1), Column(2), Column(3), Column(4), Column(5), Column(6), Column(7), Column(8), Column(9), Column(10)) > 25, Expresion1)

If(RangeMin(Column(1), Column(2), Column(3), Column(4), Column(5), Column(6), Column(7), Column(8), Column(9), Column(10)) > 25, Expresion2)

If(RangeMin(Column(1), Column(2), Column(3), Column(4), Column(5), Column(6), Column(7), Column(8), Column(9), Column(10)) > 25, Expresion3)

and so on....

[mgranillo]

I have calculated measures.  I don't have a field or dimension that stores the value so I can't use an if statement or simple set analysis.  I'm able to use advanced search set analysis but my expressions are getting ridiculously complex.  Hoping for an easier way.

[mgranillo]

That's it.  Still owning these boards I see.  Thanks Sunny!

[mgranillo]

Sunny,

I have another variant to the same problem.  How would I show only the dimensions with any column greater than 25?  An if statement? Or is there a better way?

[sunny_talwar]

So if even one of them is greater than 25, you would like to see the dimension? May be this

If(RangeMax(Column(1), Column(2), Column(3), Column(4), Column(5), Column(6), Column(7), Column(8),Column(9), Column(10)) > 25, Expresion1)

[mgranillo]

Okay now i'm feeling dumb.  Thanks.