Filter on a measure.

[system]

Hi,

How can I filter on “1”?? Below is my variable. I want to display on 1 in the report…

=If Min() In <= Then 1 Else 0

Thanks

---

eye_candy (BOB member since 2005-03-18)

[system]

There is a FAQ question that talks about this:

FAQ: Reporter

Why can’t I filter on a Report Aggregate? Answered by Dave Rathbun: It’s done that way to prevent an infinite loop. You can filter on the report level, you just can’t filter on an aggregate. That’s because the filters define the aggregate, not the other way around. Process: Return data to the cube Apply filter Display data Calculate aggregates If you tried to apply a filter after displaying the aggregates, you would loop back to step 2 and have to recalculate your aggregate. At which point…

What you can do is apply a rank to your 0/1 result, and pick the top 1 value (which should show only the 1’s and drop the 0’s). The problem with this is if there are all 0’s, then you see everything.

---

Dave Rathbun (BOB member since 2002-06-06)

[system]

Hi Dave,

Thx for your reply. But this variable I created is a measure. I want to display only 1’s am not able to do that. Ranking option is greyed out.

---

eye_candy (BOB member since 2005-03-18)

[system]

Please read up on how ranking works. You don’t rank the measure, you use the measure to rank something else. In other words, pick a dimension from your block and use the rank… then select this variable (the 1/0 one) to use for the ranking. Select the “top 1” value.

---

Dave Rathbun (BOB member since 2002-06-06)