One count only shows grand total

[Anonymous]

I have created 4 measures, each does a count of ticket numbers on a specific column on 4 individual tables. The measures are all the same, see two examples below:

Total Incidents = COUNT('SR Incidents Closed'[Number])

Total Changes = COUNT('SR Changes Closed'[Number])

However, when I then add them to a chart by month, it does show the data from 3 of the tables as monthly totals as required, but for Incidents it shows the grand total of all 12 months against each month. Any suggestions?

Monthly chart

[Anonymous]

Many thanks folks, the relationship was not active as I had a relationship with another table that was stopping it. Once I deleted the other one I could activate this one, and it now works. Thanks for the support.

[PabloDeheza]

Anytime!

Please mark as solution so we can close this topic!

Have a nice day!

[Anonymous]

folks for the replies.

The relationships are between 'Closed' in the SR tables, and 'Month' in the GAG Costs table.

[PabloDeheza · Accepted solution]

There is a relationship, but what is can see is that the relation**bleep** is inactive. You should activate it in order for GAG Costs to filter Insidents

[PabloDeheza]

Hi @Anonymous !
Check if the relationship between the table where the date is comming from, and 'SR Incidents Closed' is correct. Check if its active, if both columns in the relationship have the same data type...

Let me know if that helps!

[LQuedas]

Hi @Anonymous 

it seems to be a potential model issue, can you share a screenshot of you Model?

Cheers, LQ