Forum Discussion

albertoderossi's avatar
albertoderossi
Frequent Visitor
3 years ago
Solved

Calculate measure - count values in same table considering differente categories

I have data from lost and incoming calls and I have to count the lost calls only for number tha don't have incoming calls. If a call from a number is lost, but afterwards is answered (Incoming), that...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi albertoderossi 

    please try

    =
    SUMX (
    VALUES ( 'Table'[TESDE] ),
    IF ( CALCULATE ( SELECTEDVALUE ( 'Table'[TIPO DE LLAMADA] ) ) = "Lost", 1 )
    )

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi albertoderossi 

please try

=
SUMX (
VALUES ( 'Table'[TESDE] ),
IF ( CALCULATE ( SELECTEDVALUE ( 'Table'[TIPO DE LLAMADA] ) ) = "Lost", 1 )
)

  • albertoderossi's avatar
    albertoderossi
    Frequent Visitor
    3 years ago

    That's the one! so simple, Thanks