I could not see your problem in the sample data you send, it works normally, although I noticed you set (The relevent) on MSA, and (read all data) on ZIP, I think you may need to make it reverse you nee zip to work on MSA filtered data ...
Hello, Thanks for the fast response.
Yes, I did have relevant set on the wrong filter, but the issue is still there. If you move relevant to Zip Code, then filter to Phoenix MSA and zip code to 'All' (enable in customize), it shows the values of every single zip code. That is a normal operation I understand, but I have one row of data that already aggregates all numbers for Phoenix. I'm trying to figure out how to use that record when 'All' is selected so I don't have to have tableau do all the calculations.
Hope I made sense.
Here is a look at it in the data. I have all numbers for each MSA aggregated before tableau. Same goes for the zip codes.
What I understand from your post is that you have a row with (zip = null) in this row you aggregated some measures on MSA level, and when the user select (MSA Name) then you need to have an option to filter on this row because (ALL) option in zip filter will bring all zip codes...
Here is an idea, it may help
1- create calculated field called (ZIP C) as follow:
if ISNULL([Zip]) then '(All)'
2- Show filter on it and use (Relevent) option.
3- change the default sort type (from default properties) to desc.
4- from filter (customize) elminate the (All) option (Because we now have another calculated ALL).
5- remove the old zip filter from zip.
Then You will get something like the below picture
That seems to be a great solution for me. Tried and is working. Thanks!
You are welcome