2 Fact Tables connection with 1 Date Calender (Dimension Not Working)

[Anonymous]

Hello, guys.

I'm sorry if my English is not that clear.

I have 2 related fact table and in each one has an Date Type like following image. The ID_Order conection is Active betwen the Fact Tables but in Fact Approved Table I have an inactive connection to Dim Date.

I have a repot using Date Slicer with Dim Date[Date], but when I create a view to show Total Date_Approved by Departament it only shows me the approved amount that was sold in Demand Sales in this period. But I wanna know the Total Approved in this Date, even if hasn't the Demand Sales in this Period like following image.

Do you have any idea how I can create this Dashboard? 

Thanks.

[Greg_Deckler]

Sample/example source data would help tremendously. You have the expected output, which is good, but it doesn't make any sense without the example data where it comes from. 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

That being said, I am wondering if my Time Intelligence The Hard Way would be applicable in this situation. 

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

[Anonymous]

Unfornutally I can't share the PBI file. But I'd like to see the result like that:

I hope I'm clear this time.

Thanks.

[v-danhe-msft]

Hi @Anonymous,

Could you please share a simple sample data to have a test if possible?

Regards,

Daniel He