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

HassanMoosa — Mon, 04 May 2020 08:04:44 GMT

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

Correct
Total sum of each category per month is ruined as well total no. of responses also get wrong as correct value is 479
Total 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.

ID	Start time	Completion time	Email	Name	How was slides sharing quality	How was sound quality	How was the camera quality	Overall learning experience	Any suggestions or issue you are facing?	Campus	Overall motivation
1	3/22/20 14:37:01	3/22/20 14:38:52	XYZ@XYZ.com	XYZ	5	5	5	5	This 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
2	22/03/2020 14:44	22/03/2020 14:44	XYZ@XYZ.com	XYZ	5	5	5	5	No	Sydney	4
3	22/03/2020 14:48	22/03/2020 14:49	XYZ@XYZ.com	XYZ	4	3	3	4	Good working	Dubai	4

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

dax — Thu, 07 May 2020 02:07:41 GMT

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.

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

HassanMoosa — Thu, 07 May 2020 04:46:38 GMT

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

topic Re: How to find cumulative frequency by likert scale category and date and by using date drill down. in DAX Commands and Tips

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

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

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