Conditonal filter from two different charts

Hi, is there a way to filter the matrix based on what is being selected(clicked) by the user

CHART1 = leftmost barchart

CHART2 = right upper barchart

CHART3 = right lower barchart

Current Scenario:

- User clicks on any bar from chart1, chart3 gets filtered by current value(hours)

Desired Scenario:

- User clicks on any bar from chart1, chart3 gets filtered by value(names)

- User clicks on any bar from chart2, chart3 gets filtered by value(hours)

I made a calculated column:

Selected Column =
Var Result = CALCULATE(FIRSTNONBLANK('General'[Adjusted App],1))
Return
switch(True(),
CALCULATE(DISTINCTCOUNT('Investments Application Table'[Category]))=1,Result,
CALCULATE(DISTINCTCOUNT('Adjustments Table'[Adjustments ID]))=1,FIRSTNONBLANK(General[Hours Spent],1)
)

However, something seems to be wrong and it returns an error of: Expressions that yield variant data-type cannot be used to define calculated columns.

To summarize what I need: any bar from chart 1 is clicked, chart3 matrix values = names. any bar from chart2 is clicked,

chart3 matrix values = hours.

I hope someone can help. Thank you in advance.