Any One Instance / At least One

[HUlm1]

Hi, I have three tables:  "purchase orders" ; "jobs" and "quotations"

In "quotations" I have a Yes/No column which shows whether a Job requires materials from our Parent Company (lets call them ABC and the column [ABC HIRE YN]. 

I want to check that: If the Column 'ABC HIRE YN' = "Yes" for a particular job, then there is at least one purchase order to ABC in the purchase order table.

So far I did the following: I added a column Called ABC PO YN] to the Purchase Orders which picks out ABC as follows. If(Purchase orders [supplier]="ABC"; "Yes"; "No").  

My visual includes 'Jobs',[Job Number], 'Purchase Orders'[PO Number], 'Purchase Orders'[ABC PO YN],'Quotations',[ABC HIRE YN].  'ABC Hire YN' is filtered to "Yes" and I want to filter 'ABC PO YN' to "No"

The problem is that of course there are loads of Purchase orders for a project which are not to ABC.  I just need to know if AT LEAST one is.

I do hope that the above is an adequate explanation of the problem!
Thank you

[fhill · Accepted solution]

There's probably a smoother way of doing it, but I just COUNT'ed "YES" for each PO, and if that COUNT was > 0, then 'YES Present' else 'Yes Not Present'.

FOrrest

[HUlm1]

Brilliant!  Thankyou.  Worked a treat

[Greg_Deckler]

@HUlm1 - Hard to say exactly without sample data to test with. But, many times what you would do would maybe do a SUMMARIZE and see if there is a row for what you are looking for or a COUNTROWS(FILTER(...))

Beyond that, Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.