# 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.

- Skill: `ecnu-icalk/dax-calculated-column-for-group-sum-ignoring-columns` (Agent Skill)
- Install (CLI): `npx skillmds@latest add ecnu-icalk/dax-calculated-column-for-group-sum-ignoring-columns`
- Raw SKILL.md: https://api.skillmd.com/api/skills/ecnu-icalk/dax-calculated-column-for-group-sum-ignoring-columns/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: ECNU-ICALK (https://skillmd.com/u/ecnu-icalk)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/ecnu-icalk/dax-calculated-column-for-group-sum-ignoring-columns

---


# 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