Forum Discussion
Report is too slow
Hi thank you for your fast answer. I did not know my DAX measures were the root of all evil. It was suggested to me on this very forum when I asked on some help on making it. Being a novice I did not think to think about the performance of it all.
So what I have is a table with one line for each performance snapshot. Each line contains information of the employee it's connected to as well as values for 4 different questions (question 1 and 2 have values between 1 and 5 and questions 3 and 4 are binary. A final column it contains is the number of hours related to the performance snapshot. Each question has a different 'weighted score' table where it has a column with the name of the employee and the weighted score for a question. This wieghted score is calculated the same way for each question. See the pictures below for more information. The first one shows what I want to achieve with the weighted questions. The second one shows how it's being done at the moment.
Thanks a lot already for your help, really appreaciate it
Hi Matthias93,
It seems like I provide a low performance method, you can try to use below method if it has better performance.
1. Add calculate column and measure to get the current value.
Measure: calculagte the total hours.
Total =
var temp= LASTNONBLANK(Table1[Team Member],[Team Member])
Return
SUMX(FILTER(ALL(Table1),Table1[Team Member]=temp),[Number of hours])
Calculate column:
Current Value =
[Number of hours]*[Question 1 Value]/[Total]
2. Summary the table.
Summary table= SUMMARIZE(Table1,[Team Member],"Result",SUM(Table1[Current Value]))
Regards,
Xiaoxin Sheng
Hi,
I tried this and it seems to be working nicely. I have the impression performance has improved, but it can still be quite slow. This could indeed be due to the slicers I have on each page.
Thanks for helping me out!
Kind regards,
Matt
Hi @ Matthias93,
As said I have an impression that the number of slicers and dependency between the slicers and the charts play a significant role in the report performance. I have performance issues on one of my report although I don’t have any measures or significant calculations and the number of data is way lower than what I usually have. The only difference to my other reports is number of slicers.
Try duplicating your report to another tab then remove few slicers and test performance again. I’m sure that the performance will improve. This will just help you answer the question, Is it the number of slicers or the calculation intensive measure causing the performance issues.
If it is number of slicers, then we both have another issue which I have no clue how to resolve J. Maybe a new post or bug report to Microsoft will help.
Regards,
Ermin
Removing all slicers but one did indeed make the report faster, but still not fast enough in my opinion, especially when considering how small my dataset is at the moment. The slicers always cross-filter when you make a selection, this indeed eats up a lot of the performance.
Kind regards,
Matt
Hi,
I have another question regarding this topic. In my table I have a true/false column, would there be a way to get the weighted scores for all columns that contain true and false, a weighted score for only false rows and a score for only true rows?
Kind regards,
Matt
Hi Matthias93
did you already solve this topics with weighted score. If not can you please explain a bit more in detail what are you trying to achieve?
One more question, any luck with the performance tuning and reducing slicers?
Hi Ermin,
I was able to solve this issue. For the slicer, I notided the report indeed became faster when leaving out some of them. Thanks for the tips.
Kind regards,
Matt
