Visual With resources exceeded (measures)

[Spotto]

hello everyone, I have a panel that I made that has performance problems because it is taking too long to process the information and it is giving an error.

I have 3 tables where I made a primary key (CHAVE(CAK+NrJDE) in each and with summarize I created a table (CHAVE(CAK+NrJDE) with all the keys of each table because each table has different keys between them.

The gdp_vw_Contratos table has 250 thousand records

CHAVE(CAK+NrJDE) = DISTINCT(

FILTER(

    UNION(

SUMMARIZECOLUMNS(

    'gdp vw_Contratos'[CHAVE(CAK+NrJDE)],

    'gdp vw_Contratos'[PDDMCT],    

    'gdp vw_Contratos'[NDoc_JDE]

),

SUMMARIZECOLUMNS(

    'CDP - Salesforce'[CHAVE(CAK+NrJDE)],

    'CDP - Salesforce'[CONTRATO],    

    'CDP - Salesforce'[NR DOCUMENTO JDE]    

),

SUMMARIZECOLUMNS(

   'gdp vw_Interface_Month'[CHAVE(CAK+NrJDE)],

    'gdp vw_Interface_Month'[PDDMCT],    

    'gdp vw_Interface_Month'[VOUCHER]

)

    ),

    NOT ISBLANK('gdp vw_Contratos'[CHAVE(CAK+NrJDE)])

)

)

---> the panel I made was this:

CONTRATO = PDDMCT (table CHAVE(CAK+VOUCHER)

VOUCHER = table gdp vw_Interface_Month

TIPO = table gdp vw_Interface_Month

REGIONAL = table gdp vw_Interface_Month

GDP = measure

SALESF = measure

VALOR = table gdp vw_Interface_Month

RESPONSAVEIS = table gdp vw_Interface_Month

DT PGTO = table gdp vw_Interface_Month

Measure: 

GDP = IF(

    SELECTEDVALUE('gdp vw_Interface_Month'[CHAVE(CAK+NrJDE)]) = SELECTEDVALUE('gdp vw_Contratos'[CHAVE(CAK+NrJDE)]),

    1,0

)

SALESF = IF(

    SELECTEDVALUE('gdp vw_Interface_Month'[CHAVE(CAK+NrJDE)]) = SELECTEDVALUE('CDP - Salesforce'[CHAVE(CAK+NrJDE)]),1,0

)

Would you like some help, please, to analyze what you could do differently to improve performance?

If I take the two measures of the panel does it work so would it be possible to improve the measure?

[Anonymous · Accepted solution]

Hi @Spotto ,

1. Use filtered data, if possible.

Solved: Resources exceeded

Troubleshooting tile errors

2.  Try is not equal to the condition, and is generally faster than equal.

GDP = IF(
    SELECTEDVALUE('gdp vw_Interface_Month'[CHAVE(CAK+NrJDE)]) <> SELECTEDVALUE('gdp vw_Contratos'[CHAVE(CAK+NrJDE)]),
    0,1
)

You can use the performance analyzer to check this.

 Use Performance Analyzer to examine report element performance in Power BI Desktop

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum