Forum Discussion
Helper IIHow many calls at the same time?
Hello,
maybe someone can help, i would appreciate it.
I want to know how many calls were at the same time, i got this data from 1 day:
If i do this manually:
Is this even possible?
10 Replies
- amitchandak
Super User
virus190 , Try a new column
measure =
var _1 = [Accepted]
var _2 = [Hang up]
return
if(not(isblank(countx(filter(table, [Accepted] >= _1 && [Accepted] <= _2),[Call ID]))),"x", blank())or
measure =
var _1 = [Accepted]
var _2 = [Hang up]
var _3 = [Call ID]
return
if(not(isblank(countx(filter(table, [Accepted] >= _1 && [Accepted] <= _2 && [Call Id] <> _3),[Call ID]))),"x", blank())
virus190Hello amitchandak ,
this also works, so thank you for the quick solution, but it also only works with a few rows (look at my answer to Icey)
Do you have a solution with a lot of rows?
- Icey
Community Support
Hi virus190 ,
Try this:
column = VAR _1 = [Accepted] VAR _2 = [Hang up] VAR t = ADDCOLUMNS ( FILTER ( 'Table', 'Table'[CALL ID] < EARLIER ( 'Table'[CALL ID] ) ), "col", IF ( ( _1 <= [Accepted] && _2 > [Accepted] ) || ( _1 >= [Accepted] && _1 <= [Hang up] ), 1 ) ) RETURN IF ( NOT ( ISBLANK ( COUNTROWS ( FILTER ( t, [col] = 1 ) ) ) ), "x" )Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
