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

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

eagletro so you only want data where the system name is populated but not with the ""select from list"  - if you using import mode in power query you can filter that data out.  is this what you asking?

 

when you say search, are you wanting to use a filter in the visual, can you just explain a little more as to the output you are expecting.

eagletro's avatar
eagletro
Frequent Visitor
9 years ago

I want to see the amount of calls per system. Ive used the description as a way to do this. ive filtered select from list and on each system name to get a figure. not perfect but best i can do from the data.

 

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    9 years ago

    eagletro ok so are you saying you have extracted select * from the description? and then you are filtering on it?

     

    i mean unless you have some other indicator to identify each system this makes sense to do, if you can build some kind of rule around it in the background and use that rule to generate a smaller column to filter on is that what you look for?   these sort of things are best done in power query rather than dax in my opinion