I came across the situation , when i was drill down on “Null” field to a detailed view, i got the entire result set. Basically null filter is not gone to detail view , and i got the entire dataset of the table. It was in the same table.
Use a view instead of the original table. Handle the null in the view (COALESCE or ISNULL)
Thanks for the update. But is it a bug ?
Why i am asking is , it works fine in case of custom queries like general questions .
But only not working in case of dashboard to detailed view .