Forum Discussion

Julia2023's avatar
Julia2023
Helper I
1 year ago
Solved

Measure Improvement

Hi Community, Any ideas on how to adjust this step to improve model performance? Loading results is quite slow right now.   Classification = IF(     [Sales Ranking] > 0.8,     "First",     "Se...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks for the reply from Kedar_Pande , Kedar_Pande  and lbendlin , please allow me to provide another insight:

    Hi, Julia2023 

    You might also consider adding the following custom column in Power Query:

    if [Column1]>=0.8 then "First" else "Second"

    Power Query loads data into memory when processing, optimising memory usage and reducing memory pressure during subsequent calculations.

     

    Of course, you can also perform performance optimisation checks in the following location within the desktop application:

     

    For further details, please refer to:

    Use Performance Analyzer to examine report element performance in Power BI Desktop - Power BI | Microsoft Learn

    Please find the attached pbix relevant to the case.

     
    Of course, if you have any new discoveries or questions, please feel free to get in touch with us.
     

    Best Regards,

    Leroy Lu

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