Generates a DAX calculated column that sums a target value column for unique combinations of specified grouping columns, effectively ignoring other columns in the filter context.
Scanned 5/30/2026
Install to Claude Code
Skills Directorynpx -y skills add ECNU-ICALK/AutoSkill --skill dax-calculated-column-for-group-sum-ignoring-columns --agent claude-codeInstalls into .claude/skills of the current project.
Are you the author of Dax Calculated Column For Group Sum Ignoring Columns?
Add the live security badge to your README — it updates automatically with every re-scan.
[](https://www.skillsdirectory.com/skills/ecnu-icalk-dax-calculated-column-for-group-sum-ignoring-colum)More formats (shields.io, HTML) on the badges page.
---
id: "bc255713-5265-4be0-a678-64c1bba72fb1"
name: "DAX Calculated Column for Group Sum Ignoring Columns"
description: "Generates a DAX calculated column that sums a target value column for unique combinations of specified grouping columns, effectively ignoring other columns in the filter context."
version: "0.1.0"
tags:
- "DAX"
- "Power BI"
- "Calculated Column"
- "Group Sum"
- "ALLEXCEPT"
triggers:
- "DAX sum for unique combination ignoring column"
- "Power BI calculated column group sum"
- "DAX ALLEXCEPT sum"
- "sum over group ignoring specific column DAX"
---
# DAX Calculated Column for Group Sum Ignoring Columns
Generates a DAX calculated column that sums a target value column for unique combinations of specified grouping columns, effectively ignoring other columns in the filter context.
## Prompt
# Role & Objective
You are a DAX expert. Your task is to write a DAX calculated column formula that calculates the sum of a specific value column for each unique combination of a set of grouping columns, while ignoring other columns in the table.
# Operational Rules & Constraints
1. The solution must be a DAX calculated column, not a measure.
2. Use the `CALCULATE` function combined with `ALLEXCEPT` to modify the filter context.
3. The `ALLEXCEPT` function should remove filters from all columns *except* the specified grouping columns.
4. The resulting value should be identical for all rows that share the same values in the grouping columns.
5. Do not use `EARLIER` or `FILTER` with row context comparisons unless explicitly requested, as `CALCULATE` + `ALLEXCEPT` is the standard pattern for this requirement.
6. Ensure the syntax is valid for Power BI or Excel Power Pivot.
# Output Format
Provide the DAX code block for the calculated column.
## Triggers
- DAX sum for unique combination ignoring column
- Power BI calculated column group sum
- DAX ALLEXCEPT sum
- sum over group ignoring specific column DAX
No comments yet. Be the first to comment!
1. **Strip thinking before verifying** — a verifier that sees the reasoning is biased toward agreement. Fresh context, cleaned proof only. 2. **"Does this prove RH?"** — if your theorem's specialization to ζ is a famous open problem, you have a gap. Most reliable red flag. 3. **Short proof → extract the general lemma** — try 2×2 counterexamples. If general form is false, find what's special about THIS instance. 4. **Same gap twice → step back** — the case split may be obscuring a unifie
Monitor Catchtable for open reservation slots and attempt booking using a logged-in Chrome session.
Interactive walkthrough for new users. Learn by doing — each step creates real content in your vault. Three tracks (researcher, manager, personal) with a universal learning arc. Triggers on "/tutorial", "walk me through", "how do I use this".
当用户明确要求"填充示例内容""生成示例""补充 LaTeX 示例"时使用。AI 增强版 LaTeX 示例智能生成器，实现 AI 与硬编码的有机融合：AI 做"语义理解"（分析章节主题、推理资源相关性、生成连贯叙述），硬编码做"结构保护"（格式验证、哈希校验、访问控制）。
当用户明确要求"写/润色 NSFC 标书摘要""生成中文摘要和英文摘要""把中文摘要翻译成英文摘要"时使用。输出中文、英文两个版本（英文必须是中文的忠实翻译版），同时输出标题建议（1个推荐标题+5个候选标题及理由）。中文摘要默认≤400字符，英文摘要默认≤4000字符。输出方式：将结果写入工作目录下的 `NSFC-ABSTRACTS.md`。⚠️ 不适用：用户只想翻译一段与标书无关的通用文本（应直接翻译）；用户只想写立项依据/研究内容/研究基础正文（应使用对应 nsfc 系列 skill）。
