How do you combine two running totals in a Dax measure?

[SpokingAround]

Hi,

This my first post, so please bear with me... I have tried to give as much info as possible but it is commercially sensitive data so am unable to share the file itself.

I have two tables of records. Each table has a recordID column of unique values, that I use to count the number of distinct records. I have successfully created two running totals.

However, I now wish to combine them, and am completely stumped on how to handle the scenario where one of the running totals has no new data for a given date.

I have read multiple blogs on this, which conclude that linking to a central date table was the answer along with using the USERELATIONSHIP function. I believe I have this set up correctly.

I am pulling my hair out on the issue... Where am I going wrong?

Thanks

SpokingAround

[lbendlin]

You will want to include a calendar table in your data model, and then use the date column from that calendar table as your base for the calculation of the measures.