Optimising the report
Hi, I am trying to optimise my report which is fetching the output for two months but not fetching the output for two years. The measure that needs to be optimsed is below: /* Rank = IF ( NOT ( ISBLANK ( [Total Amount Paid] ) ), RANKX( FILTER ( SUMMARIZE ( ALL ( 'Fact Claim' ), 'Fact Claim'[DOS_NETWORK_LICENSE_KEY], 'Fact Claim'[PROVIDER_KEY], 'Provider'[PROVIDER_KEY], Provider[Name], Provider[Provider GID], 'Network License'[NETWORK_LICENSE_KEY], 'Network License'[Network License Number] ), Provider[PROVIDER_KEY]='Fact Claim'[PROVIDER_KEY] && 'Network License'[NETWORK_LICENSE_KEY]='Fact Claim'[DOS_NETWORK_LICENSE_KEY] ), [Total Amount Paid],,,Dense ) ) Can you please let me know that how can we re-write this measure in order to make it more optimised? Thanks, Ekta