Conditional Many to One Relationship Question

[krwalke]

Hi Group,

I'm relatively new to Power BI, and am stuck on pulling just one specific value to return from a many to one relationship.  My data set below (Table A - Many side of the relationship) shows each JobID having multiple Milestones, but not necessarily every Milestone.  In a separate table (Table B - One side of the relationship) that the JobID is relationshipped with (Many to One), I'd like to show a true/false or some kind of output for only one specific Milestone - let's say 100.

So, if the JobID in Table A has a 100 Milestone, then True, else False.. for all JobIDs in Table B.

Table A:

Hopefully this makes sense and thanks for the help!

[Shaurya · Accepted solution]

Hi @krwalke,

Filter Table A first to create a new table that only has the IDs with a specific milestone.

Milestone IDs = FILTER('Table A','Table A'[Milestone]=100)

Then create a flag in Table B that shows true or false based on the fact whether that ID is present in the filtered table or not.

Flag = IF(ISBLANK(LOOKUPVALUE('Milestone IDs'[Job ID],'Milestone IDs'[Job ID],'Table B'[Job ID])), "False", "True")

Works for you? Mark this post as a solution if it does!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI