Dax to return value from multiple fact tables

[H_insight]

Hiya,  

I have the below model in Power BI. 

Above dimensions have one to many relationship with a single cross filter direction.

What I am after is having a single table showing Demand value based on the below context. I need a dax to help me achieve that.

Any help is greatly appreciated. I have been trying for a while now.

I thought changing context for Calculate would work, but not in my case.
Calculate( sum(demand value), Fact_consumer)

[amitchandak · Accepted solution]

@H_insight , Ideally, across common dimension

Sum(Fact_consumer[demand value])

Should work

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.