How to do cummilative sum of likert scale category by date.

[HassanMoosa]

Hi, 

I am trying to do sum of likert scale category (1, 2, 3, 4, 5) by date drill down.  Like when I drill down to month it should just show the cumulative sum of each category by that month total no of responses and so on.  But now it is just showing total sum of categories but when drill down to month and day its sum runies.  I made new table and grouped it by "Overall learning experience" and applied count rows operation but its not working when Drill down to month and day.  

Please guide me how to group likert scale data and find cumulative sum of each category (1, 2, 3, 4, 5) and total responses by each month and days by using DAX or what so ever. 

The pictures of the charts are attached below:

1. In picture 1 all good.
2. In picture 2 its showing wrong cumulative sum by month I want cumulative sum by each month e.g: March 73, April 393, May 13 thus cumulative should be 479.
3. Similarly in picture 3 it shows cumulative sum in thousands.  It should again be as per days.  And sync to all other visuals. 

Please see my data below. 

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	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.	XYZ	5
2	22/03/2020 14:44	22/03/2020 14:44	XYZ@XYZ	XYZ	5	5	5	5	No	XYZ 2	3
3	22/03/2020 14:48	22/03/2020 14:49	XYZ@XYZ	XYZ	4	3	3	4	Good working	XYZ 3	2

[Anonymous]

Sorry but your explanation is not clear. Please refer to this:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best
D

[HassanMoosa]

@Anonymous thanks for sharing the article.  I will follow yr gudelines.  Meanwhile I will try to communicate again.   I have a data of 479 students who have given their feedback in lickert scale of 1-5.   I want to count each of this catagory on each  date hierarchy.  For example, on May 1 what was the count  of students who rated for scale 1, 2 3, 4 and 5.  Similarly this will show for each day and I also want their sum.  When I try to do that I do not get the actual sum of these counts.

If you still dont get I will try again to rephrase. 

Regards.

[Anonymous · Accepted solution]

Please find the solution attached.

Best

D

[Anonymous]

By the way, make sure you've got the latest version of Power BI Desktop. This is important because if you haven't, you can get an error when opening the file.

Best
D

[HassanMoosa]

@Anonymous thanks for sharing.  I tried to work with it but still was stuck at some point.  Is it possible if i send you teams meeting invation for further calrifications through which we could do screen sharing session...only if its fine to you. 

[Anonymous]

OK. That's more like it 🙂 I think I know how to do this. I'll post a file with a model shortly.

Best
D