Forum Discussion
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 need a way of finding as close to the amount of tickets per system as possible. All i can think of is looking at the description field and search for the list of system's. Any idea of how to do this?
see screenshot below
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
6 Replies
eagletro not quite clear on what you asking are you wanting to know how many tickets have that issue?
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.
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.
