Optimising the report

[Ekta_dq]

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

[quantumudit]

Always use ADDCOLUMNS() with SUMMARIZE() and please consider only specific columns (needed for ranking) in the first part of FILTER() function to create the virtual table

[amitchandak]

@Ekta_dq m

'Fact Claim'[DOS_NETWORK_LICENSE_KEY],
'Fact Claim'[PROVIDER_KEY],
'Provider'[PROVIDER_KEY], // This only need if you want plot rank against Provider
Provider[Name], // is it above 'Provider'[PROVIDER_KEY], again need rank against Provider[Name],
Provider[Provider GID], // same as avove
'Network License'[NETWORK_LICENSE_KEY], //This only need if you want plot rank against Network License
'Network License'[Network License Number] // do want rank against this column.

reconsider some of those if they are needed or not