cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ritar_li
Regular Visitor

How to identify a service number that is associated with two service names?

Hello, 

I'm trying to identify service # that includs two service names A AND B. My table is

ServiceService#
A1
B1
A2
A5
A3
B3
B4

 

I'm a new user to Power BI. If this question is duplication of previous post(s). Please direct me to right track. I appreciate your help ahead.  

 

Hong

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@ritar_li , A new column

new column =

var _1= calculate(distinctcount(Table[Service]), filter(Table, [Service#] =earlier([Service#]) && [Service] in {"A", "B"}))

return

if(isblank(_1), false(), true())



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@ritar_li , A new column

new column =

var _1= calculate(distinctcount(Table[Service]), filter(Table, [Service#] =earlier([Service#]) && [Service] in {"A", "B"}))

return

if(isblank(_1), false(), true())



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!