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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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