DAX to show sum based on another table filter by another table

[Anonymous]

I want to calculate sum of Plan based on Well Purpose & Year.

Note that Year(table1), Well Purpose(table2) and Plan(table3) are from different tables. 

I created a measure where Plan = SUM(table3[count_plan]) but it only shows total of plan based on year. It does not filter Well Purpose.

By the way, I want to put this measure in table2. Please help me.

[v-jingzhang]

@Anonymous Did you create a relationship between table2 and table3? If you did, what is the filter direction between them? The measure should work if a correct active relationship has been created. 

Reference: Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs

[amitchandak]

@Anonymous , Can you share sample data and sample output in table format?

Ideally should have common tables for year and well purpose to filter the tables

https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/

You can create a common table like -https://youtu.be/Bkf35Roman8