2 of 2 people found this helpful
You could drag your measure to the filter, choose special, then non-nulls
Did you mean the Rank measure or the Volume of Traffic measure?
I'm using the Rank measure, but the mistake is already in there. I need to do something to the Rank calculation to make sure that any nulls aren't included in the rank and are kept as nulls.
If that makes sense!
1 of 1 people found this helpful
I changed your rank to:
if not isnull(sum([volume of traffic])) then index() end
I think that works - I now don't need anything on the filter shelf
That works a treat Alex, thanks ever so much.