Forum Discussion
Slow Dax with 9M rows
I am building a dashboard to get the counts of active employees on a specific date. This has come with quite a few challenges. The original data set has 400K rows. Here is the look of the test data: ...
PaulDBrown
Community Champion
Community ChampionWhen you say you have unpivoted a column, which column is it? (Is the table you posted the result after unpivoting or before?)
you should also create a date table with continuous dates covering the range of dates in you model.
can you share some sample (non-condidential) data?
https://www.dropbox.com/s/rxy2scwedp4zfv0/test%20data.pbix?dl=0
I created this test file that is the overall picture of my dashboard. Let me know if you are unable to download.
Right now, the date measure isn't working, but the logic is at any date, they can see the active count of employees by the detail they choose. In my dashboard, there are 13 columns unpivoted. All of the ones that the user can choose to see the level of detail of.
Thank you!