Create an measure with a condition from an other unrelated table.

[Akkoustic]

Im pretty new to Power BI and DAX. So I've got a table Project and a table Opportunity. 

I want to calculated the Estimated revenue win rate. This will be done by  [Total Est. Won]   /  [Total Est. Won/Lost]

First step in my mind is to figure out what [Total Est. Won] is. 

Opportunity has a column named status with Won, Lost and Open. Project has the Est. Revenue.

I want in project,  a measure where I can get my first step done. So far I tried this and it returned me blank. I assume this is because I dont have any relation between them. Is there any way I can get this done withouth a relationship between these tables?

Measure:

Total Est. Won := CALCULATE(SUM(Project[Est. Revenue (Base)]),FILTER(RELATEDTABLE(Opportunity),[Status] = "Won"))

[Anonymous]

Hi Akkoustic

I fear this is not possible. Think about what you are asking in that DAX formula.

It is like saying to someone "Count how many apples are on the tree, where the fish in the sea are green" there is no connection. You need a common field in both tables or a third table joining them. 

As a guess, i would think you have x Opportunities per project (or x projects per Opportunity)? Perhaps there is a customer name or location or something common to both?