DAX query to find percentage of few categories within column
Hi, can anyone guide me an efficient BI DAX Query to find percentage of only two categories like in my case I want to take percentage of 1 and 2 out of 1-5 scale rating ignoring the missing values in the column, rest all data set to be included. e.g.: Poor Feedback % = 1(category) + 2(category) / Out of all data set "Excluding missing values" * 100 Below is the screenshot of my likert scale and column name.How to do cummilative sum of likert scale category by date.
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: In picture 1 all good. 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. 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
