Column in table calculated by filter on view

[VeljkoP98]

Hello everyone,

Solutions	Regions	Year
Solution 1, Solution 2, Solution 3	Region 1	2022
Solution 1, Solution 2	Region 2	2023
Solution 3, Solution 2	Region 3	2022
Solution 1, Solution 4	Region 1	2023

I would like to see if there is a possibility to do the following:
I would like to have an additional table with just the Solutions and counter on how many times certain Solution X appears. 
However i would like to have multiple several dashboards, where I can filter Years or Region, and by filtering those I will get different values, like for example:

Solution	Number
Solution 1	x
Solution 2	y
Solution 3	z
Solution 4	u

x,y,z,u - are the number of appearances of Solutions in Column Solution based on the filter you use.

View 1: I filter on the page Region 1, and then i can plot Bar Chart that is going to show me in Region 1 count of Solution 1/2/3/4. 
View 2: I filter on the page Year 2023, and i can plot Bar Chart that is showing me only for Year 2023 representation of how much Solution 1/2/3/4 appeared.

However i am aware that this is hard to implement as multiple filters on multiple pages can make a mess in column. I would like to hear your ideas and suggestions. I know that i can create new columns for each filter option, but since i have multiple Years and multiple Regions, this would mean that i need to make many different columns.

Thank you for your advices in advance.

BR. 

[DataInsights · Accepted solution]

@VeljkoP98,

Using Power Query, I would split the Solutions column into rows:

Then trim the leading space in Solutions and you'll have data that is easier to use:

[VeljkoP98]

Seems like an great idea. However would it be possible to split column into rows but in another Table as i want data in this table to stay the same.

[DataInsights]

@VeljkoP98,

Sure, you can create a second table in Power Query. Right-click the query and select "Reference", and the new query will point to the original query. Apply the steps above to the new query.