How to filter duplicate columns with same filter values separately in matrix visualization -PowerBI

[deb_power123]

Hi Experts,

I have a table named sales with three columns: 1)QuaterYear 2)Place 3)SalesAmount-scenarioA.

I have duplicated the column 'SalesAmount-scenarioA' and named it 'SalesAmount-scenarioB in modelling view of PowerBI.I have added 2 filters for values QuaterYear with name QuaterYearscenarioA and QuaterYearscenarioB in my visualization .

I want my filters to filter these two duplicate columns seperately in the table visualization as if they are two different columns and they arent related to each other.For example: if I filter the first column 'SalesAmount-scenarioA' then the values of SalesAmount-scenarioB'should not change.Rightnow if I select any value in first filter the second filter gets preselected and both the column values gets changed. Though I understand why it happens but my reuirement is to filter both these columns independently. In other words like implementing filter columns in table visualization, since powerBI doesnt have one so I am trying to workaround.

This will help me to compare the values through filter for different Quateryear for different scenarios.

How can I handle this case , is there any DAX Calculations or measures you could provide me which I can try? Please help. I have added my input data values for reference .

My modelling tab: where I duplicated the columns

My visualization:

Input data source-Excel

QuaterYear	SalesAmount	Place
Q12017	1000	London
Q12017	1100	London
Q12017	1120	London
Q12017	900	Tokyo
Q22017	2200	Tokyo
Q22017	2100	Tokyo
Q22017	1000	Tokyo
Q22017	500	Tokyo
Q22017	1900	Tokyo
Q22017	1900	Tokyo
Q22017	2000	Tokyo
Q22017	4000	Tokyo
Q22017	2100	Tokyo
Q32017	1100	Singapore
Q32017	890	Singapore

[deb_power123]

@Greg_Deckler  Could you please take a look of the issue? and provide your suggestions on calculations or visualizations to handle this scenario.Also is there any viusualization with dropdown filter on column headers in powerbi.It can also help my case scenario.Please suggest