to simplify for me, you have fact table 1 realated to your date table and fact table 2 related to your date table, both facts should be the many side of the relationship. depending on the cardinality of your facts you may actually have created the relationship backwards. If you have a 1 ->1 relationship based on the data in the tables you may have created the relationship 1->* fact to dimension. would be very easy for me to diagnose if i had your pbix file.
@dkay84_PowerBI - data types are set correctly, double-checked. Regarding your last post - those are already taken care of via calculate(countrows( and then a logic statement as the filter (was a demo used or not).
@richbenmintz - below is a simplified version of the file, but all of the data, relationships, calculations, etc. are conceptually the same. Hope this helps.
After looking over the shared sample pbix file, I think you should use the formula below to calculate "Total Demos". After changing that, you should get the proper result.
Total Demos = CALCULATE ( COUNTROWS ( Demos ), USERELATIONSHIP ( BasicCalendarUS[DateKey], Demos[Open_Stamp__c] ) )
the issue was your relationships cros filter behhaviour settings, they were all set to Both. a given that repIndex was joined to both closed and demo tables the basiccalennderUS table would filter Demos through Closed and RepIndex. By Updating the relationships to be single direction you are able to define an active relationship between BasicCalendarUS and Both fact tables. See Screen shot below. Your scenario does not call for any Dax aside from sum.
you will also find the pbix with updates here: