Forum Discussion

Ekta_dq's avatar
Ekta_dq
New Member
5 years ago

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
optimised

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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

     

     

  • quantumudit's avatar
    quantumudit
    Super User
    5 years ago

    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