한국어
☰ Categories

DAX Terminal

a DAX terminal for Microsoft's analytical services.

CategoryDevelopment › Data & databases
TagsDraftingDeveloperCode
Prompt
I want you to act as a DAX terminal for Microsoft's analytical services. I will give you commands for different concepts involving the use of DAX for data analytics. I want you to reply with a DAX code examples of measures for each command. Do not use more than one unique code block per example given. Do not give explanations. Use prior measures you provide for newer measures as I give more commands. Prioritize column references over table references. Use the data model of three Dimension tables, one Calendar table, and one Fact table. The three Dimension tables, 'Product Categories', 'Products', and 'Regions', should all have active OneWay one-to-many relationships with the Fact table called 'Sales'. The 'Calendar' table should have inactive OneWay one-to-many relationships with any date column in the model. My first command is to give an example of a count of all sales transactions from the 'Sales' table based on the primary key column.

What this prompt does

This is useful for quickly getting DAX measure examples for a specified Sales data model. It replies with a single code block and no explanation, so changes are needed if the model differs from the prompt's assumptions.

Model comparison

ChatGPT and Gemini are effectively equal and correct; [C] is missing and ranks last.

ChatGPT
48/ 50

+ Correctly counts the inferred primary key.

- The SalesKey column name was not specified.

Gemini
48/ 50

+ Provides a concise, valid single DAX block.

- It assumes the primary key is named SalesKey.

CriterionChatGPTGeminiLeader
Instruction following1010Tie
Accuracy99Tie
Specificity99Tie
Structure1010Tie
Right length1010Tie

Scored 1–10 by gpt-5.6-sol with model names hidden (2026-09-25). This is an AI review, not a measurement.

Read full answers

We gave three models the same input and copied their answers unedited. Each ran in its CLI (an agent harness), and answers in the ChatGPT or Claude apps or on the web may differ. Outputs are in Korean.

gpt-5.6-luna (codex CLI · 에이전트 하네스) · Run on 2026-09-24
총 판매 거래 수 =
COUNT ( 'Sales'[SalesKey] )

More in this category

Advanced Text Converter for Large Datasets
AI-powered data extraction and organization tool
AI2sql SQL Model — Query Generator
Backend Architect
base-R