issues starting with serial at didderent loaction as 1 issue

[Anonymous]

hi
i have  a column Issues using which i have to show all the issues in a graph
i want to consider all the issues starting with serial at didderent loaction as 1 issue 

[Anonymous · Accepted solution]

Hi  @Anonymous ,

Here are the steps you can follow：

1. Create calculated column.

new =
IF(CONTAINSSTRING('Table'[column],"Serial at different location"),"Serial at different loaction",'Table'[column])

2. Create measure.

count = COUNTAX(FILTER(ALL('Table'),'Table'[new]=MAX('Table'[new])),'Table'[new])

3. Result:

Best Regards,

Liu Yang

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

[amitchandak]

@Anonymous , second part is not clear ,

Create a measure

calculate(countrows(Table), filter(table, left([column],6) ="Serial" && Search("Location",[Column],,0) >0))

[Anonymous]

hi amit

i have used your measure but it is still showing the division of serial at different location.
i just want to show all the serial at different location as one