Forum Discussion

jsentiscr's avatar
jsentiscr
Regular Visitor
7 years ago
Solved

IF / COUNT IF

Hi, I have this formula where I filter for several conditions.       1- The first conditions search in the columns if any data contains the word (DEFAULT, MASIVO, etc) in part of its text a...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    jsentiscr,

     

    As the error message mentioned, the format of some columns like [@[ID SERVICIO]] is not number type, so they can not be used in comparision with 0, you should change the type from text to number or use value() function to convert them.

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    jsentiscr,

     

    You may use DAX function like FIND, SEARCH, PositionOf and Contains, you may refer to the text function in link below:

    https://docs.microsoft.com/en-us/dax/find-function-dax

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

jsentiscr,

 

As the error message mentioned, the format of some columns like [@[ID SERVICIO]] is not number type, so they can not be used in comparision with 0, you should change the type from text to number or use value() function to convert them.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jsentiscr's avatar
jsentiscr
Regular Visitor
7 years ago

Hi, perfect, thank you very much, I will review, on the other hand, ¿I'm using well the way to find part of the text and Count the data?

 

 

Example of correct names:

 

DEFAULT_HONDURAS, 

ENLACE_DEFAULT_SV 

MASIVO_HN

EQUIPO_MASIVO_SV

SV_ESC_HN_DEF001_HN

 

EXCEL: 

 

=IF(AND(COUNTIF([@[ID SERVICIO]];"*DEFAULT*")=0;COUNTIF([@[ID SERVICIO]];"*MASIVO*")=0;COUNTIF([@[ID SERVICIO]];"*ESC_HN_DEF001*")=0;"VALIDO";

 

DAX:

 

=SWITCH(TRUE();CALCULATE(COUNT(TICKETS[ID SERVICIO]);TICKETS[ID SERVICIO]="*DEFAULT*")=0 && CALCULATE(COUNT(TICKETS[ID SERVICIO]);TICKETS[ID SERVICIO]="*MASIVO*")=0 && CALCULATE(COUNT(TICKETS[ID SERVICIO]);TICKETS[ID SERVICIO]="*ESC_HN_DEF001*")=0;"VALIDO";
 
What is the proper form or formula in DAX to search for words within a text?
 
Thanks.
  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    jsentiscr,

     

    You may use DAX function like FIND, SEARCH, PositionOf and Contains, you may refer to the text function in link below:

    https://docs.microsoft.com/en-us/dax/find-function-dax

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.