I have an issue with defining rank on a measure. My defined measure displays either a 1 or a 0. I would like to show all 1’s on the report. When I apply the rank to the user name dimension variable nothing happens. (I still am displaying all 1’s and 0’s) What am I doing wrong?
I am selecting ‘top’ and typing in 1. Then picking my measure in the drop down list.
truc0011 (BOB member since 2008-01-17)
Try putting a filter on the table, where your measure = 1.
MichaelWelter 
(BOB member since 2002-08-08)
My measure is not available in the filter list of variables…is it defined at the report level.
truc0011 (BOB member since 2008-01-17)
You can still use it in a table filter.
MichaelWelter (BOB member since 2002-08-08)
How if its not available in the list of variables when I go to add to the filter?
truc0011 (BOB member since 2008-01-17)
If it’s not in the list of variable, then you didn’t create a variable, you created a formula. You’ll need to convert the formula to a variable to use it in a filter.
MichaelWelter (BOB member since 2002-08-08)
It’s a variable. It is a measure defined at the report level…I think the issue is there are sum()'s in it.
truc0011 (BOB member since 2008-01-17)
That could be. You can’t filter based on an aggregate because the aggregate results change based on the filter. It creates a circular reference. Can you build the variable without the sum() function?
MichaelWelter (BOB member since 2002-08-08)