Forum Discussion

danieldefo's avatar
danieldefo
Frequent Visitor
8 years ago
Solved

weighted average for survey result

Hi all, I would really appreciate your help with the following. I have some figures as in the following excel example. The figure in this screenshot it is just count of respondent answers for spes...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    In the column area section of the visual, drag the Value field from the reporting PulseCheckSurvey table.  In the file that you shared with me over a private message, this formula work perfectly

     

    =IF(HASONEVALUE('reporting PulseCheckSurvey'[Value]),[Number of Respondents],SUMX(SUMMARIZE(VALUES('reporting PulseCheckSurvey'[Value]),[Value],"ABCD",MIN('reporting PulseCheckSurvey'[Value]),"EFGH",[Number of Respondents]),([ABCD]*[EFGH]))/[Number of Respondents])

     

    Hope this helps.

     

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

This is not difficult in DAX.  One has to use the SUMX() function.  Share your dataset.

danieldefo's avatar
danieldefo
Frequent Visitor
8 years ago

HI, please this is my dataset, in my calculation for number of candidates  in second picutre, I have  used distincount

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    Not very sure but try this

     

    =IF(HASONEVALUE(Data[Value]),your_measure,SUMX(SUMMARIZE(VALUES(Data[Value]),[Value],"ABCD",MIN(Data[Value]),"EFGH",your_measure,"IJKL",[ABCD]*[EFGH]),[IJKL]/your_measure))

     

    If this does not work, then share the link from where i can download your file.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      8 years ago

      Hi,

       

      In the column area section of the visual, drag the Value field from the reporting PulseCheckSurvey table.  In the file that you shared with me over a private message, this formula work perfectly

       

      =IF(HASONEVALUE('reporting PulseCheckSurvey'[Value]),[Number of Respondents],SUMX(SUMMARIZE(VALUES('reporting PulseCheckSurvey'[Value]),[Value],"ABCD",MIN('reporting PulseCheckSurvey'[Value]),"EFGH",[Number of Respondents]),([ABCD]*[EFGH]))/[Number of Respondents])

       

      Hope this helps.

       

       

      • danieldefo's avatar
        danieldefo
        Frequent Visitor
        8 years ago

        Dear Mathur,

         

        Thanks for your help.It works perfectly

         

        Have a nice fruitful day