optimizing
1 Topic
DAX Query optimization
Hey, Looking for some query optimization tips. I am having query as below, which is performing in around 3000ms (979 FE, 1766 SE). How would you guys change this query in order to get better report response time :)? MEASURE [%] = IF ( ( SUM ( Number ) / ( DISTINCTCOUNT ( Date ) * 5 ) ) > 1, 1, SUM ( Number ) / ( DISTINCTCOUNT ( Date ) * 5 ) ) Thanks in advance!Solved766Views0likes2Comments