tableau - How to use Calculated Members to convert a Dimension to Measure

问题描述:

I have a dimension having the following hierarchy:

Service Area: Y,Z and Y: A,B and Z: C

I am using an Analysis cube as a data source. I want to create a parameter having Y and Z and then a filter connected to it having A,B and C as options. I.e. When someone selects Y, He gets the filter option shown as A and B and when he selects Z, the filter option changes to C. I tried using the Calculated member but I am not quite clear about its concept. Can someone tell me an easier way to do it.