Forum Discussion
Helper IIhelp with DAX calculation
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 |
3 Replies
ChiragGarg2512Solution Sage
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).
haniizzChiragGarg2512
many thanks for giving time to solve this , may I have the pbx file