Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Anyone know about MinMaxColumnPositionCallback in DAX Studio server timings?

I've run a trace on my DAX query, and many rows in the server timings show MinMaxColumnPositionCallback in bold, indicating it is a performance problem. I googled and get zero results.   Has anyone...
Poojara_D12's avatar
Poojara_D12
Icon for Super User rankSuper User
1 year ago

Hi Anonymous 

The MinMaxColumnPositionCallback  in server timings indicates that Power BI is calculating the minimum and maximum positions of a column, often due to filtering or range queries on large datasets. This can cause performance issues, especially with high-cardinality columns.

How to Fix:

  1. Optimize Columns:

    • Reduce cardinality (e.g., group dates into hierarchies).
    • Use summarized data instead of raw values.

  2. Refactor DAX:

    • Simplify filters and calculations.
    • Use variables to avoid redundant operations.

  3. Optimize Relationships:

    • Use single-direction relationships where possible.
    • Avoid bi-directional filtering unless necessary.

  4. Check Visuals:

    • Simplify slicers or pre-filter data in Power Query.

  5. Use DAX Studio:

    • Analyze query performance and pinpoint bottlenecks.

Refining filters, columns, and relationships will usually resolve this issue.

 

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS