Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
harshnathani
Community Champion
Community Champion

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
dax
Community Support
Community Support

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
harshnathani
Community Champion
Community Champion

@camargos88 ,

 

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

 

Slicers will be Type, Location and Year.

 

Regards,

Harsh Nathani

@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!



@camargos88 ,

 

Unable to get the total count of surveys.

 

Regards,

Harsh Nathani

@harshnathani ,

 

Try it using COUNTROWS.



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

Proud to be a Super User!



dax
Community Support
Community Support

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.

camargos88
Community Champion
Community Champion

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!



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors