This post describes a way to create a calculated mesaure which is boolean (TRUE/FALSE):
1. Consider 2 measures x and y . Lets create a new calculated measure called z derived out of x and y.
2. z is boolean and is determined by the x and y values. How ? lets assume z = x - y
3. If x > y then , lets say z has to show false else true.
4. Frame an MDX in the formula for calculated measure like :
NOT (Measures.x - Measures.y)
5. The format string of z should be "True/False".
1. Consider 2 measures x and y . Lets create a new calculated measure called z derived out of x and y.
2. z is boolean and is determined by the x and y values. How ? lets assume z = x - y
3. If x > y then , lets say z has to show false else true.
4. Frame an MDX in the formula for calculated measure like :
NOT (Measures.x - Measures.y)
5. The format string of z should be "True/False".
No comments:
Post a Comment