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...
Hello Hemant_Jaiswar ,
Instead of removing all context with ALL(dwdim_customer[CustomerName]), consider using ALLSELECTED(). This keeps the context of other filters, which can significantly reduce the number of calculations.
VAR _topCategory =
RANKX(
ALLSELECTED(dwdim_customer[CustomerName]),
CALCULATE([CY #Value NOS], ALL(Dim_Date[Date])),,DESC)
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!
Thank You
Dharmendar S