help with DAX calculation

[haniizz]

Hello Community

I need your help with performing this, I have this table

ID	Sex	Age	Finance status	health status	Mental Status
1	Male	20-30	good	very bad	good
2	Male	10-20	very good	bad	bad
3	Female	20 - 30	bad	good	very bad
4	Male	50-60	very bad	No Answer	very good

What I need is to create a Matrix like below , that shows the sum of positive answers ( good + very good ) , and sum of negative answers ( bad + very bad ) , I need the matrix to be like this 

Title : Finance Status

Gender	Positive	Negative
Male	3
Female		1

Title : Health Status

Gender	Positive	Negative
Male		2
Female	1

[haniizz]

@ChiragGarg2512 

many thanks for giving time to solve this , may I have the pbx file

[ChiragGarg2512]

@haniizz 

Create two measures[positive and negative] for every column. Then create 3 different tables or create a field parameter using all these measures and select 2 of the measure options to show in the table visual.

Here is the implementation:

6 measures were created[2 for each status] and then fed to field paramter that gave this slicer. Putting Sex and field paramter into table visual and selecting from slicer should provide this result.

Thank You.

[ChiragGarg2512]

@haniizz , I tried my other 2 solutions but was not able to work with them, here is a solution(The last response has been edited).