Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
CONTRATO = PDDMCT (table CHAVE(CAK+VOUCHER)
VOUCHER = table gdp vw_Interface_Month
Measure:
Solved! Go to Solution.
Hi @Spotto ,
1. Use filtered data, if possible.
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
Hi @Spotto ,
1. Use filtered data, if possible.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |