Need help DAX & Matrix

[haniizz]

Hi Community ,

I need help with DAX formula that count the sum of positive answers ( good, Very good ) and sum of negative answers ( Bad , Very Bad ) and reflect that in 3 Matrix

to be like this
Matrix 1 : ( Health )

Gender	positive	Negative	No Answer	Do Not Know
Male	4	2	1	1
Female	2	3	0	0

and so on for the other categories ( finance , emotions )

pbix file 

Thank you in advance

[lucadelicio · Accepted solution]

Hi,

here the link with the pbix

https://we.tl/t-vMdkToWg1E
You need to create a FACT table with the answers and a DIMENSION table with the user.
Then you have to connect with the relationship ONE to MANY.
Study what is a DIMENSION (the unique value: examples client, supllier, employes etc...)
and a FACT your data (examples invoice, calls, events etc..).u
To create the fact table you need to use Power Query in the transform data.
Create one table for every type of answer: Finance, Health, Emotions and then APPEND it in a new one the only one table that you import.

To create the DIMENSION table you need to do the distinct value of your users.

IF RESOLVER YOUR PROBLEM PLEASE MARK IT AS A SOLUTION.

Regards,

Luca D'Elicio

[haniizz]

Dear Luca,

words are not enough to express my appreciation and gratitudes to your kind support

but thank you any way

this solved my issue

kind regards

[lucadelicio]

I send you the request to download the file from the drive.

Thank you

[haniizz]

Hi Luca, sorry something with that file 

but here is another link pbix file  

thank you for your intension to support

[lucadelicio]

I can't download it.

Please use https://wetransfer.com/
it's free.

Thank you

[haniizz]

Thank you Luca the link is so helpful

here is the pbix file pbix