What problem does it solve? DAX formulas in Power BI reports often suffer from slow query performance, poor readability, and violations of best practices, making reports sluggish and hard to maintain. This Skill provides a structured expert review that diagnoses issues and produces an optimized rewrite with explanations. ## Core Features & Use Cases - Performance Analysis: Identifies expensive operations, repeated expressions, inefficient context transitions, and suboptimal function choices such as COUNT versus COUNTROWS. - Structured Optimization Workflow: Follows a four-step process covering current formula analysis, optimization strategy, the rewritten formula, and justification of every change. - Best Practices Enforcement: Applies VAR usage, DIVIDE instead of the division operator, SELECTEDVALUE instead of VALUES, and proper BLANK handling. - Use Case: A report developer has a year-over-year sales growth measure that renders slowly when filtered by multiple dimensions. Submitting the formula returns an optimized version using variables and a single PARALLELPERIOD calculation, plus an explanation of the expected performance impact. ## Quick Start Optimize this DAX formula for performance and readability, explaining each change: paste your measure definition and describe its business purpose and any performance issues.
