Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I need a formula to calculate the percentage above 15 seconds in this column. Thanks in advance!
Solved! Go to Solution.
hi @rigginb
try to write a measure like this:
Pct =
VAR _count =
COUNTROWS(
FILTER(TableName, TableName[Agent Answer Time]>=15)
)
VAR _countall =COUNTROWS(ALL(TableName[Agent Answer Time]))
RETURN
DIVIDE(_count, _countall)
hi @rigginb
try to write a measure like this:
Pct =
VAR _count =
COUNTROWS(
FILTER(TableName, TableName[Agent Answer Time]>=15)
)
VAR _countall =COUNTROWS(ALL(TableName[Agent Answer Time]))
RETURN
DIVIDE(_count, _countall)
User | Count |
---|---|
49 | |
40 | |
18 | |
14 | |
13 |
User | Count |
---|---|
100 | |
55 | |
28 | |
18 | |
13 |