Summing a Column by Grouping by another column and creating conditions

ismail95 — Tue, 09 Apr 2024 06:59:16 GMT

Hi, I try to create the meausure/ table below, and need your help. I want to sum Assessment column grouping by Task Name. After that I will compare Sum of Assessments with the tasks threshold ( logic provided below)

Re: Summing a Column by Grouping by another column and creating conditions

Dangar332 — Tue, 09 Apr 2024 10:17:43 GMT

Hi, ismail95

try below measure for logical test

drag your task and assessment column to table visual and add below measure

Measure = SWITCH(TRUE(), MIN(assessment[task])="a" && SUM(assessment[assessment])>5,1, MIN(assessment[task])="b" && SUM(assessment[assessment])>3,1, MIN(assessment[task])="c" && SUM(assessment[assessment])>6,1,0)

topic Re: Summing a Column by Grouping by another column and creating conditions in DAX Commands and Tips

Summing a Column by Grouping by another column and creating conditions

Re: Summing a Column by Grouping by another column and creating conditions