cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## issues starting with serial at didderent loaction as 1 issue

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

1 ACCEPTED SOLUTION
Community Support

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.

3 REPLIES 3
Community Support

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.

Super User

@Anonymous , second part is not clear ,

Create a measure

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

Anonymous
Not applicable

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.