Date Table Showing Incorrect Month Number

[MiguelSantos]

What I am trying to accomplish -- Create a divergent bar chart of open closed issues by month, where the closed cases show as negative in the month they were resolved.

Like this graph I created below but the numbers are pretty far off:

Problem/s -- 

First thing I noticed is my calendar table relationship is not working as I thought I should. I have a calendar table built like this.

And this table with an inactive relationship

The strange thing is that when I create a basic table with the date of the incident and try and get the month number from the calendar table it reflects incorrect numbers and can't really wrap my head around why.

Secondly, I am trying to calculate the number of issues closed each month using the following measure; however, whenever I add the measure to the bar chart it just adds the counts to the month the issues were open. 

Any help would be appreciated. I dont know if this is a fairly basic concept but I am having a hard time wrapping my head around it.

[MFelix]

Hi @MiguelSantos ,

First of all check if the type of the columns on the relationships are the same so all that relate with the calendar

table shoud be has a date.

What is the active relationship you have between the calendar and the BD is it based on created date or on date of incident? The active relationship is the one that is used on the table image you present on with the incorrect month, and is also the one that is used when you use a column on the visualization or create a simple metric such has countrows.

If this does not help can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

[MiguelSantos]

MFelix thank you for your time and assitance. 

What is the active relationship you have between the calendar and the BD?
So the active relationship, I have between the 8D and the calendar is via my fact table. 8D[key] 1 --> * Fact Table[key] -- >Calendar

However, I have an inactive relationship between my 8D table and my calendar table
8Ds[8D Resolve Date Rel] (This column is a duplicate of the Resolved Date) --> Calendar[date]

Ill keep working on this with your provided suggestions and report back with what happens. Im kind of convinced I have made a spiderweb of relationships between my tables that I am struggling to correct.

[MFelix]

Hi @MiguelSantos ,

If you want can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.