Oh I think I see what you mean now... sorry.
One possible way is to to use a custom parameter and two calculated fields. For instance, if the parameter is set to all, the first field is District and the second field is State. Else State and Local. Then you could use a series of On/Off switches to check if the selected parameter is equal to each district else name district null and filter out the nulls. Ill produce an example in a few minutes.
Here is the workbook. I left in the "Product Type" field in there just to illustrate how the parameter is filtering the data, but it can be removed without any effect.
Let me know if you have any questions.
Parameter Filter Example.twbx.zip 169.1 KB
How did you make Parameter 1 include the All field? When I tried to make a parameter, I only had the list of values as an option, but not the All.
I manually set all the parameter values, so I put "All" as one of my choices of the parameter.
If you notice in my calculated fields though, when I select "All" as opposed to one of the other options, it causes the Product/State measure and the State/Market measure to switch.
IIF([Parameter 1]="All", [Product Type],[State])
IIF([Parameter 1]="All", [State],[Market])
So if its set to "All" it shows Product and State, if it is one of the other parameter values, it shows State and Market