Need help to optimize the power bi P&L

[desterpp]

Hello,

I have a problem to visualize the power BI. In fact the dax calculations take much time.

[v-jialongy-msft]

Hi @desterpp 

If you're experiencing slow performance with DAX calculations in Power BI, here are some strategies to improve efficiency:

• Simplify Calculations: Complex DAX formulas can slow down performance. Consider breaking down intricate formulas into simpler parts.

• Optimize Data Model: A more streamlined data model with fewer tables and relationships can enhance performance. Remove any extraneous columns or tables.

• Prefer Measures Over Calculated Columns: Generally, measures perform better than calculated columns, especially in larger datasets.

• Apply Filters to Reduce Data: Filtering to minimize the amount of data being processed can speed up calculations.

• Avoid Unnecessary Iterations: Functions like  and  can be performance-intensive. Ensure they are used judiciously.CALCULATEFILTER

• Utilize Performance Analyzer: Power BI's Performance Analyzer tool can help identify which visuals are loading slowly, guiding your optimization efforts.

^{Best Regards,}

^Jayleny

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}

[desterpp]

Hi @v-jialongy-msft 

I am sorry but i can't accepted your recommendation as a solution because i am still locked with the performance.

Best Regards