Forum Discussion

MorganBauwens's avatar
MorganBauwens
New Member
3 years ago
Solved

Count multi-callers in multiple services

Hello all,   I'd love to get some help with DAX.   Here is the context :  We have a hotline with multiple call-centers. All the events are recorded in a PowerBI Dataset. Here are the main column...
  • johnt75's avatar
    johnt75
    3 years ago

    Try

    Cust called twice =
VAR SummaryTable =
    ADDCOLUMNS (
        VALUES ( 'Service Task'[Initial SIP from] ),
        "@num call centres", CALCULATE ( DISTINCTCOUNT ( 'Service Task'[Initial SIP to] ) )
    )
VAR Result =
    COUNTROWS ( FILTER ( SummaryTable, [@num call centres] >= 2 ) )
RETURN
    Result
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

Try

Cust called twice =
VAR SummaryTable =
    ADDCOLUMNS (
        VALUES ( 'Service Task'[Initial SIP from] ),
        "@num call centres", CALCULATE ( DISTINCTCOUNT ( 'Service Task'[Initial SIP to] ) )
    )
VAR Result =
    COUNTROWS ( FILTER ( SummaryTable, [@num call centres] >= 2 ) )
RETURN
    Result
  • MorganBauwens's avatar
    MorganBauwens
    New Member
    3 years ago

    That is exactly what I needed, johnt75 !
    Thanks a lot for your help !