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 "Su...
  • 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])

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.