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.
Hi,
I have some issues with the performance, I create a report to calculate Slope and Intercept value but very slow to get the value.
I'm looking for some recomendations tips or tricks to solve the performance issue.
DeviceID, Seq, TotalTime, Time and DP are source data.
Airflow and Fan Efficiency are "What-If" parameters.
Below is the sample data ( actual total rows is 1083)
DeviceID | Seq | TotalTime | Time | DP | PAVG_Operation | Energy | Energy Cumulative |
10042de | 1 | 0 | 0 | 236.833 | 236.833 | 0 | 0 |
10042de | 2 | 0.5 | 0.5 | 219.95 | 219.95 | 0.2597 | 0.2597 |
10042de | 3 | 0.8333 | 0.3333 | 213.933 | 213.933 | 0.1684 | 0.428 |
10042de | 4 | 1.3333 | 0.5 | 228.25 | 228.25 | 0.2695 | 0.6975 |
10042de | 5 | 1.6667 | 0.3333 | 224.4 | 224.4 | 0.1766 | 0.8741 |
10042de | 6 | 2.1667 | 0.5 | 237.817 | 237.817 | 0.2808 | 1.1548 |
10042de | 7 | 2.3333 | 0.1667 | 230.333 | 230.333 | 0.0907 | 1.2455 |
10042de | 8 | 2.6667 | 0.3333 | 256.783 | 256.783 | 0.2021 | 1.4476 |
10042de | 9 | 2.8333 | 0.1667 | 245.317 | 245.317 | 0.0966 | 1.5441 |
10042de | 10 | 3.1667 | 0.3333 | 243.717 | 243.717 | 0.1918 | 1.7359 |
10042de | 11 | 3.3333 | 0.1667 | 223.5 | 223.5 | 0.088 | 1.8239 |
Here is the pbix file
https://www.dropbox.com/s/27om27u8acnwovk/SamplePowerBI.pbix?dl=0
and Source data file
https://www.dropbox.com/s/i9kd76dhs9gr87p/SampleData.xlsx?dl=0
Thanks in advance.
Solved! Go to Solution.
Hi @phoisan ,
The main cause of performance issues may be SUMX and AVERAGEX .
You could refer to below blogs to optimize your DAX formula:
Tune your PowerPivot DAX query, don’t use the entire table in a FILTER and replace SUMX if possible
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @phoisan ,
The main cause of performance issues may be SUMX and AVERAGEX .
You could refer to below blogs to optimize your DAX formula:
Tune your PowerPivot DAX query, don’t use the entire table in a FILTER and replace SUMX if possible
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your reponse. I'm new to Power BI and I'll try out
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |