Creating a column filtered on values in a related table

[stranter]

Hi,

I am trying to recreate an SSRS report in Power BI.  The report has a smmary page thus:

Agreement Value

Billing Account

Service Account

Agreement Number

Total Number of Orders

Number of Outstanding Orders

Outstanding £

Number of Invoiced Orders

Invoiced £

Total £

In Power BI, I have following tables:

Agreements

n--->1 Billing Accounts

n--->1 Service Accounts

1--->n Orders

        1--->n Bookings

I can reproduce the summary page in it's entirety apart from:

Outsanding £

Invoiced £

These columns need to sit in an Order record and are the sum of related Bookings, split according to the status of a Booking.  How do I do this?

Thanks,

Stewart

[stranter · Accepted solution]

I solved it by using this article.  The code for my calculated column is:

Invoiced £ = 
var invamt = CALCULATE(sum(Bookings[costtocustomer]), Bookings[Status] = "Completed")
return invamt

Stewart