Agent skill · Audited from source
Dax Calculated Column For Group Sum Ignoring Columns
skill · ECNU-ICALK/AutoSkillLicence not declaredAudited 14 Oct 2026 · source 04e912cff54b
Is it safe? Yes — SAFE, grade B (89/100). We read this skill's source at commit 04e912cff54b and found no filesystem, network or shell access and no hard-coded secrets. What it does: 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.
Cite
Cite this page
ModelsAtlas. “Dax Calculated Column For Group Sum Ignoring Columns (ECNU-ICALK/AutoSkill)”. Retrieved 14 Oct 2026. https://modelsatlas.com/skills/ecnu-icalk/dax-calculated-column-for-group-sum-ignoring-columns
Trust audit
Audit 0.4.1 · source read 14 Oct 2026
SAFE means nothing in the source contradicts what the skill says it does. Grade B is shared by 16,667 of 17,602 audited skills.
What the source does
- FilesystemNone observedNo reads or writes in the source
- NetworkNone observedNo outbound calls in the source
- ShellNone observedNo commands run in the source
- DependenciesPinnedNothing floats
- SecretsNone foundNo keys in source
Five audit layers
| Layer | What we check | Result | Findings |
|---|---|---|---|
L0 Provenance | Repo owner, licence, archive status, activity | PASS | 0 |
L1 Static source | Secrets, path traversal, supply chain, hidden code | NA | 0 |
L2 Instructions | Prompt injection, authority framing, hidden directives | PASS | 0 |
L3 Inventory | The files and declarations match the source | PASS | 0 |
L4 Sandbox | Run in isolation and watch behaviour | SKIPPED why | 0 |
Gates applied: no behavioural pass.
Findings (0)
No findings at any severity. We re-audit when the source changes.
Audit 0.4.1 · source sha 04e912cff54b · 14 Oct 2026Report an issue or request a re-scan
Provenance
Who published it, and what the verdict is pinned to
- PublisherECNU-ICALK GitHub organizationOwner of the repository this skill is read from
- Source folderECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/dax-calculated-column-for-group-sum-ignoring-columnsThe exact folder we audited
- LicenceNot declaredAs the repository states it
- Commit pinned for this verdict04e912cff54bA new audit runs when the source changes
- Repository statusNot archivedLast push 157 days ago
- Sandboxed runNot runSkills are read, not executed; layer L4 is skipped
What it tells the agent
Full source on GitHub ↗Its 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.
--- 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
Excerpt, first 1,960 characters of SKILL.md, verbatim from the audited commit. It is text from someone else’s repository, quoted so you can judge it before your agent reads it.
Install
Pinned to the audited commit 04e912c
git clone https://github.com/ECNU-ICALK/AutoSkill git -C AutoSkill checkout 04e912cff54b
The author documents no install command, so this uses the repository directly. Our verdict covers commit 04e912cff54b only.
Works in
The author has not said which agents this skill supports, and we have not tested it in any.
Audit history
Every audit, every source change
- ✓SAFE B 89 / 100
first audit · source
04e912cff54b
Similar skills
ECNU-ICALK/AutoSkill
Executes a 1-back test by comparing the current input to the immediately preceding input in a sequence, reporting the prior item and a match indicator.
ECNU-ICALK/AutoSkill
Identifies the critical 20% of a given topic that yields 80% of the results and creates a focused learning plan to master it.
ECNU-ICALK/AutoSkill
Act as a friendly English teacher for A1 students. Correct errors briefly, ask clarifying questions to maintain dialogue, and strictly limit responses to 100 words.
ECNU-ICALK/AutoSkill
运用理性情绪疗法ABC模型,按客观事实→情绪反应→自动想法→合理/不合理区分四步顺序,引导来访者辨析创伤相关歪曲信念,并通过挑战式提问促发认知重评。
ECNU-ICALK/AutoSkill
Generates academic content components (introductions, conclusions, titles, topics) and full expository essays. Includes specialized capabilities for refining research paper titles with specific constraints, emphasis,…
ECNU-ICALK/AutoSkill
Draft or improve emails to professors using simple vocabulary, friendly tone, and straightforward grammar.
Questions about Dax Calculated Column For Group Sum Ignoring Columns
What does the Dax Calculated Column For Group Sum Ignoring Columns skill do?
Is Dax Calculated Column For Group Sum Ignoring Columns safe to install?
What can Dax Calculated Column For Group Sum Ignoring Columns access on my machine?
How current is this page?
Sources
- github.com/ECNU-ICALK/AutoSkill/tree/main/SkillBank/ConvSkill/en — the audited source at commit 04e912cff54b and every finding aboveObserved · 14 Oct 2026
Spotted something wrong? Report a correction · Methodology
Keep going in your AI
Opens with this page as the source. We add nothing else to the prompt.
- What does the Dax Calculated Column For Group Sum Ignoring Columns skill do?
- Is Dax Calculated Column For Group Sum Ignoring Columns safe to install?
- What can Dax Calculated Column For Group Sum Ignoring Columns access on my machine?