Data model

Hi Anonymous 

You can connect your Date with both Table1 and Table 2
make sure your relationship from Date  to Table 1 is 1 ->many (Both direction)

and relationship from Date  to Table 2 is 1 ->many (Both direction)


put your slicer on top from Date table filed.

Or you can have bridge table where your unique values of gender/ item will be store . connect your both the tables ( 1&2) with bridge table and your issue will be resolved.

Note: You have to decide the flow of your filter data. It should be from cost table or revenue table. which is the primary or main table. based on that you can take unique value in bridge table and decide the flow like single direction and both direction.
Advice: Never create relationship with many to many direction avoid using that . it creates ambiguity. you can reolved this by using bridge table.

I hope above solution would help you to make your model working.