Compare entries between two data

[medlalami]

Hi all,

I have a table named DimDate that contains Dates in different format. And another table named Problems, that have two fields (created on and closed on), that I linked with the field Date, available on DimDate table:

First relation and active one:

The second relation (non active):

Now on my graph, I need to display and compare between the created problems, basing into the creation date, and the closed problems (basing into the closure date). I have also a field name State, that contains following values:

• Assigned
• Draft
• In Progress
• Closed
• Resolved

I need to display my graphe like that:

But I can only display the created problems, because the relation is active:

I'm confused and I know that something is wrong but I can't see whats wrong.

[medlalami · Accepted solution]

Solved but creating a mesure:

Closure = CALCULATE(COUNTROWS(Problems),USERELATIONSHIP(Problems[Closed On], DimDate[Date]))

[medlalami]

I have a problem with the relations. The values of opened problems are correct but not the case for the closed values.