Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to 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)
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)
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |