Summing a Column by Grouping by another column and creating conditions

[ismail95]

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)

[Dangar332 · Accepted solution]

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)