Skip to main content
cancel
Showing results for 
Search instead 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

Reply
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 

greeshma_0-1623233612194.png

 

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
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:

v-yangliu-msft_0-1623396558920.png

 

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.

View solution in original post

3 REPLIES 3
v-yangliu-msft
Community Support
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:

v-yangliu-msft_0-1623396558920.png

 

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
Super User
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

greeshma_0-1623237826839.png

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors