skills.rest
francoisbgdw
francoisbgdwCOMMUNITY
Explore all skills by this author →
GitHub

dax

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
One-click install
npx skills add https://github.com/francoisbgdw/claude-skills --skill dax
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
patrikboroschpatrikborosch
14

semantic-model-authoring

Develop and manage Power BI semantic models across Desktop, PBIP, and Fabric.

Community
Advanced
JNZader-VaultJNZader-Vault

powerbi

Develop Power BI solutions with DAX measures, Power Query transformations, and dashboard designs.

Official
Advanced
marcelodfelmanmarcelodfelman

Power BI DAX

Write, execute, and optimize DAX queries for Power BI semantic models.

Community
Advanced
personamanagmentlayerpersonamanagmentlayer
41

sql-expert

Design, query, optimize, and administer SQL databases across PostgreSQL, MySQL, and SQL Server.

Official
Advanced