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,

 

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