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...
  • lucadelicio's avatar
    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