cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User V
Super User V

Survey Data

Hi Community Members,

 

I have the following survey Data. Want to calculate the total survey taken by location, Type of Survey.

 

Please help.

 

Location NameMonthYearSurvey TakenType of SurveyAvg NPSAvg Total grade
 AJanuary20200Onboarding  
 AFebruary20201Onboarding9.0010.00
 AMarch20201Onboarding9.0010.00
 AApril20200Onboarding  
 AJanuary20200Final  
 AFebruary20200Final  
 AMarch20204Final8.008.00
 AApril20202Final9.0010.00
BJanuary20200Onboarding  
BFebruary20200Onboarding  
BMarch20201Onboarding1.00 
BApril20200Onboarding  
BJanuary20200Final  
BFebruary20206Final6.007.00
BMarch20205Final9.0010.00
BApril20205Final8.509.50
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Survey Data

Hi @camargos88 , 

I am not clear about your requirement, if possible, could you please inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.

By the way, I think you could put data in table visual and use count function to create countof survey. You could refer to my sample for details.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Highlighted
Super User V
Super User V

Re: Survey Data

Hi @harshnathani ,

 

How do you expect the results ?

 



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Highlighted
Super User V
Super User V

Re: Survey Data

@camargos88 ,

 

Total Survey taken by type, Location and for a particular year.

 

Slicers will be Type, Location and Year.

 

Regards,

Harsh Nathani

Highlighted
Super User V
Super User V

Re: Survey Data

@harshnathani ,

 

Doesn't it work if you drag the fields on a table and filter by slicers ? Or you have any kind of filter to apply ?



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Highlighted
Super User V
Super User V

Re: Survey Data

@camargos88 ,

 

Unable to get the total count of surveys.

 

Regards,

Harsh Nathani

Highlighted
Super User V
Super User V

Re: Survey Data

@harshnathani ,

 

Try it using COUNTROWS.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Highlighted
Community Support
Community Support

Re: Survey Data

Hi @camargos88 , 

I am not clear about your requirement, if possible, could you please inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.

By the way, I think you could put data in table visual and use count function to create countof survey. You could refer to my sample for details.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors