Forum Discussion

haniizz's avatar
haniizz
Helper II
2 years ago
Solved

Need help DAX & Matrix

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 )

GenderpositiveNegativeNo AnswerDo Not Know

Male 

4211
Female2300

 

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

pbix file 

 

Thank you in advance

Need Help
  • lucadelicio's avatar
    lucadelicio
    2 years ago

    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

6 Replies

  • lucadelicio's avatar
    lucadelicio
    Impactful Individual
    2 years ago

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

    Thank you

  • lucadelicio's avatar
    lucadelicio
    Impactful Individual
    2 years ago

    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's avatar
      haniizz
      Helper II
      2 years ago

      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