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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
HassanMoosa
Helper I
Helper I

How to find cumulative frequency by likert scale category and date and by using date drill down.

Hi, 

 

I am new to Power BI.  Pls guide me with the problem below:

 

I have survey data which is coming every day.  I am using likert  scale (1, 2, 3, 4, 5) and wanted to do cumulative sum or frequency count for each likert category (1, 2, 3, 4, 5) with respect to date e.g: if I drill down to month it should give me cumulative sum of each category of the data in that specific month along with its total no. of data set in that month when I use waterfall chart.  My sample data set is given below.  

 

I made second table to find the sum of each category by using group by specifiying Overall learning experience column and applying count rows operation.  This provided me new table with the total count of each category but not by month, date.  When I drill down to month the sum of each category are mixed and end total responses exeeds.   Total no of responses are 479.

 

Please see the pictures

  1.  Correct
  2. Total sum of each category per month is ruined as well total no. of responses also get wrong as correct value is 479
  3. Total sum of each category per day is ruined as well total no. of responses also get wrong as correct value is 479

CorrectCorrectTotal sum of each category per month is ruined as well total no. of responses also get wrong as correct value is 479Total sum of each category per month is ruined as well total no. of responses also get wrong as correct value is 479Total sum of each category per day is ruined as well total no. of responses also get wrong as correct value is 479Total sum of each category per day is ruined as well total no. of responses also get wrong as correct value is 479

Please guide me how to solve this issue.  I wanted to see total no of responces of each category along with its independent total overall, by month, day, so on.  Also I want to make separate chart for only  1 and 2 rating by using DAX or what ever!!!

 

Regards.

 

 
IDStart timeCompletion timeEmailNameHow was slides sharing qualityHow was sound qualityHow was the camera qualityOverall learning experienceAny suggestions or issue you are facing?CampusOverall motivation
13/22/20 14:37:013/22/20 14:38:52XYZ@XYZ.comXYZ5555This is my first time to experience online classes which is very great if I see it as technology perspective. But the trainer's lecture was interesting which makes me engaged to the lecture.  I really liked the online classes concept.California

5

222/03/2020 14:4422/03/2020 14:44XYZ@XYZ.comXYZ5555NoSydney

4

322/03/2020 14:4822/03/2020 14:49XYZ@XYZ.comXYZ4334Good workingDubai4
 
1 ACCEPTED SOLUTION
dax
Community Support
Community Support

Hi @HassanMoosa , 

Thank you for your sharing! But I am not sure which column you will used to calculate value and you said that you "made second table to find the sum of each category", I can't view this table in your sample. I use another simple sample to calculate cumulative value, you could refer to it for details.

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

2 REPLIES 2
dax
Community Support
Community Support

Hi @HassanMoosa , 

Thank you for your sharing! But I am not sure which column you will used to calculate value and you said that you "made second table to find the sum of each category", I can't view this table in your sample. I use another simple sample to calculate cumulative value, you could refer to it for details.

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.

@dax thanks for helping me out.   I will look into your soultion and will get back to you soon. 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.