Using a Parameter to switch multiple attributes across multiple visuals

[chrisdiekvoss]

I am a attempting to create a user experience on the same report page for two different audiences (an owning group and a recycle group) on this page there viz for the # Applications and another for Recycle Minutes on both viz I would like to switch between the Team and Area for the seelected group. 

Field parametes can't handle the compexity and a calculated measure doesn't validate for dimensional attributtes so I am trying with a calculated column (I know these are frowned apon), the Dax validates but the selected value does not populate, it has 1 blank row with the metric. 

See attached workbook, I feel like I am either overlooking something simple or just taking the wrong approach, any guidence would be greatly apprciated.   

Show View By Team = switch (True(),'View By'[Selected View By] = "Recycling",'Data' [Recycle Team], 'View By'[Selected View By] = "Owning", 'Data' [Owning Team])

Show View By Area = switch (True(),'View By'[Selected View By] = "Recycling",'Data' [Recycle Area], 'View By'[Selected View By] = "Owning", 'Data' [Owning Area])

[danextian]

Hi @chrisdiekvoss 

See attached workbook?
You might have forgotten to post a sample data. You can post a link to an Excel file in the cloud.

[chrisdiekvoss]

Sorry, i thought i could attached a workbook, here is the sample data.

Application	Owning Area	Owning Team	Recycle Area	Recycle Team	Recycle Time
A	OA1	OT20	RA1	RT10	10
B	OA1	OT20	RA1	RT10	20
C	OA1	OT25	RA1	RT10	30
D	OA2	OT30	RA1	RT10	40
E	OA3	OT30	RA1	RT15	50
F	OA3	OT30	RA1	RT15	60
G	OA3	OT30	RA2	RT20	70
H	OA4	OT40	RA2	RT20	80
I	OA4	OT50	RA2	RT20	90
J	OA4	OT50	RA2	RT20	95