I need some help altering my measures for better performance. Its basically a ranking measure and a max of that ranking measure to create a Rank percentile across multiple levels of hierarchy.
The measures are at the EMP level and ignore the hierarchies Leader and Supervisor. See below for levels.
I was able to achieve this however when filtering data through slicers, performance is slow and 32 bit excel throws a memory error. I believe the issue has to do with Max Rank and the filter used below
See below for all measures
Anything related to PowerPivot and DAX Formuale
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 5 guests