Forum Discussion
ranking formula optimization
when i use this formula it goes on loading and takes lot of time to show output, how do i solve this problem so it loads faster Ranking = VAR _topCategory = RANKX( ALL(dwdim_cu...
To improve the performance of your DAX measure, avoid recalculating the same measure multiple times. Store the result of [CY #Value NOS] in a variable, and use ALLSELECTED instead of ALL for the RANKX function to respect any filters. This will reduce the data being processed and improve speed. Additionally, consider pre-aggregating your data or using summary tables to avoid heavy computations during runtime.
💡 If this helped, please give Kudos 👍 or mark it as a Solution ✅.
Best regards,
Kedar
🌐 Connect on LinkedIn
Best regards,
Kedar
🌐 Connect on LinkedIn