Filter only affects legend partly

[AnniekH96]

Hi everyone,

I would like to make a visual in which I show the percentage of men and women in a team within in a company compared to the percentage of the company as a whole per age group.

I plan to use for this the clusterd bar chart with age in the axis, team in the legend, and number of people in the value section. 

Currently if I filter on Team A I would only see team A, and if I don't filter I get a bar for all the teams within the company. 

What do I need for this type of graph? A dax measure, grouping ? 

[Stachu]

Can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).

Column1	Column2
A	1
B	2.5