dax

Name: dax
Availability: InStock
Author: francoisbgdw

Optimize and validate DAX queries for Power BI and Fabric semantic models.

Updated Mar 14, 2026

Search Tags:#performance #query-optimization #data-modeling #dax #measures #powerbi

Ready to run

npx skills add https://github.com/francoisbgdw/claude-skills --skill dax

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: dax
Source: https://github.com/francoisbgdw/claude-skills/tree/main/skills/dax
Command: npx skills add https://github.com/francoisbgdw/claude-skills --skill dax

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

DAX query authoring, testing, and optimization for Power BI and Fabric semantic models can be complex and time-consuming; this Skill provides structured guidance, patterns, and best practices to streamline measure creation, validation, and performance tuning.

Core Features & Use Cases

Author and optimize DAX measures for performance and correctness in Power BI reports and Fabric models.
Debug and validate calculations using proven patterns (VAR, CALCULATE, SUMMARIZECOLUMNS) with practical examples.
Use cases include building robust measures, optimizing query performance, and troubleshooting complex calc logic in large semantic models.

Quick Start

Write a simple DAX measure and evaluate it against a sample model to verify results.

Frequently Asked Questions about dax

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I optimize DAX query performance in Power BI semantic models?▼

Debug DAX calculations by validating measures using proven patterns like VAR usage, SUMMARIZECOLUMNS, and CALCULATE to isolate logic errors and test query outputs against sample models for reliable troubleshooting.

What is the best way to structure complex DAX measures using CALCULATE and VAR?▼

The best way to structure complex DAX measures is using VAR declarations to break down logic and CALCULATE patterns to manage filter context, ensuring your Power BI reports remain fast and maintainable.

Does this DAX optimization approach work for Fabric semantic models?▼

Yes, this approach applies to authoring, testing, and tuning DAX queries across Power BI reports, tabular models, and Fabric workloads, ensuring reliable measure performance in large semantic models.

Why does my DAX measure return incorrect results in large Power BI reports?▼

DAX measures return incorrect results in large Power BI reports when filter context is mismanaged; validate your CALCULATE logic and SUMMARIZECOLUMNS patterns against sample data to debug functional issues.

Can I use SUMMARIZECOLUMNS patterns for testing DAX calculations?▼

Yes, you can use SUMMARIZECOLUMNS alongside VAR and CALCULATE patterns to author, debug, and validate DAX calculations, ensuring your measures produce correct results before deploying to Power BI reports.