Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Contar con varias condiciones

Hola team,

 

Tengo una duda de cómo poder contar un dato si cumple con 3 condiciones.. El dato que quiero contar esta en la columna "Call: Ref" y para contarlo, este debe de tener en la columna "Survey" los siguientes criterios: (VISIBILITY, PROMOCION, COMPETITION), si no cuenta con estos 3 campos, entonces no cuenta la "Call: Ref".

Adjunto imagen con 2 cosos, uno cumpliendo (recuadro amarillo) y el otro no cumpliendo (recuadro rojo).

 

De antemano, muchas gracias.

 

 

  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Try a measure like


    countx(filter(summarize(filter(Table, Table[Survey] in {"VISIBILITY" , "PROMOTION", "COMPETITION"}), Table[Call: Ref], "_2", distinctCOUNT(Table[Survey])) , [_2] =3),[Call: Ref])

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , Try a measure like


    countx(filter(summarize(filter(Table, Table[Survey] in {"VISIBILITY" , "PROMOTION", "COMPETITION"}), Table[Call: Ref], "_2", distinctCOUNT(Table[Survey])) , [_2] =3),[Call: Ref])

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you very much amitchandak , it's hard for me to understand the operation of the DAX "summarize" and the filters within the function, I tried with that function but I couldn't find the right way. Thanks for the information.