Forum Discussion

eagletro's avatar
eagletro
Frequent Visitor
9 years ago
Solved

Retrive calls by System

Hi All,   retreving calls from our company ticket system and have found issues with validation (Now seen to it thats its fixed). Thus the vast majority of calls are system "select from list". i nee...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi eagletro,

    however in the decription in the vast majority of cases will contain the system name. I want a way to search the description field to look for the system name's.

    If I understand you correctly, you should be able to use FIND function(DAX) to search the description field to look for the system name's in your scenario. The formula(untested) below is for your reference. :smileyhappy:

    Count of Current System =
VAR currentSytemName =
    FIRSTNONBLANK ( Table1[SYSTEM NAME], 1 )
RETURN
    COUNTA ( 'Table1'[SYSTEM NAME] )
        + CALCULATE (
            COUNTA ( 'Table1'[SYSTEM NAME] ),
            FILTER (
                ALL ( Table1 ),
                'Table1'[SYSTEM NAME] = "Select from list"
                    && FIND ( currentSytemName, 'Table1'[DESCRIPTION],, -1 ) > 0
            )
        )

     

    Regards

eagletro's avatar
eagletro
Frequent Visitor
9 years ago

The issue is that there shouldnt be any tickets that are system name "select from list" due to our systems poor validation it allows users to create ticket without a system name.

 

however in the decription in the vast majority of cases will contain the system name. I want a way to search the description field to look for the system name's.

 

 

 

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi eagletro,

however in the decription in the vast majority of cases will contain the system name. I want a way to search the description field to look for the system name's.

If I understand you correctly, you should be able to use FIND function(DAX) to search the description field to look for the system name's in your scenario. The formula(untested) below is for your reference. :smileyhappy:

Count of Current System =
VAR currentSytemName =
    FIRSTNONBLANK ( Table1[SYSTEM NAME], 1 )
RETURN
    COUNTA ( 'Table1'[SYSTEM NAME] )
        + CALCULATE (
            COUNTA ( 'Table1'[SYSTEM NAME] ),
            FILTER (
                ALL ( Table1 ),
                'Table1'[SYSTEM NAME] = "Select from list"
                    && FIND ( currentSytemName, 'Table1'[DESCRIPTION],, -1 ) > 0
            )
        )

 

Regards