Combine similar values from 2 sources

[aflintdepm]

I have 2 data sources that are from a related process.  The first source counts all open tasks and has a start date.  The second source counts all completed tasks and also has a start date, along with a finished date.  The values in each source are unique (the same task will never appear in both sources), but the first source does not have a completed date value at all.

I would like to be able to count the total number of tasks started on a given date, regardless of which source it is on.  From there, I would want to be able to filter the location the task was assigned to.

Currently, I created a measure in each source to count the number of tasks on each source and then combined them into a third measure ( i.e. measure 3 = measure 1_source_1 + measure 2_source_2)

However, the measure does not respond to my location filters.

Any advice is welcome, but I am relatively new to Power BI, so please provide step by step

Thank you

[aflintdepm]

Thank you, @tackytechtom 

I found the error in my relationship that was blocking the filter.  I had established the wrong link between my source and my location table.  However, if there is a way to union the 2 sources, I would like to learn about that.  I will do some research on it. 

Thanks again.

[v-easonf-msft · Accepted solution]

Hi, @aflintdepm 

This is somewhat related to the model you are currently building. It is recommended to create separate dimension tables for location and date.

You can also consider combining all the data into one table and then count the number of tasks.

Measure = COUNT(Append1[Task])

Best Regards,
Community Support Team _ Eason

[tackytechtom]

Hi @aflintdepm ,

Where does the location attribute your are filtering upon come from? Are you using the location attribute direclty from either of the tables or do you have separate location (dimension) table? If so, are all connections in place?

Please feel free to share some sample data and / or the data model 🙂

Also, it might be worthwile to union those two tables (open + completed, if they are having the same columns. I have the feeling that is going to help you a lot for anything that you want to be doing later on.

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/