Trying to create a chart from a single dataset with 2 independent line parmaeters

[Anonymous]

I'm currently reviewing service desk data and want to plot 2 lines in the same category then be able to filter on a member of the team.

I've got my main dataset which is pulled from an API, in the data it has 2 date fields, Created & Resolved.

In my chart I want to be able to filter on a person to determine:

1. The number of calls they've logged
2. The number of calls they've closed

Where it gets conveluted is, if they have logged the call, they are the reporter; if they have closed the call, they are the assignee.

I'm trying to create:

1. A line which shows a count of calls where the reporter is X
2. A line which shows a count of calls where the assignee is X

I've created a supplementary table in my data which is an index of names to link to, but the filtering is inaccuate.

I've created 2 measures to bring me back the counts:

ResolvedDate-Id = CALCULATE(COUNT(DataSet1[assignee]),USERELATIONSHIP(CalendarDates[Date],DataSet1[Resolved]))

CreatedDate-Id = CALCULATE(COUNT(DataSet1[Reporter]),USERELATIONSHIP(CalendarDates[Date],DataSet1[Created]))

I can currently filter on Reporter and 1 line is correct, or filter on Assignee and the other is correct, but I'm trying to filter on 1 for both. Any help would be appreaciated,

[Anonymous]

Hi @amitchandak 

Thanks for your response. I am indeed using the CalendarDates for the report axis.

I've removed the sensitive data from the pbix but it still serves the same purpose

Here is a link to it

The example I've been working is RYA and you can see that there is differences when filtering on assignee, reporter and the external table field, TeamMemberID (i think that's what I called it)

[amitchandak]

@Anonymous , this seems correct. Are you plotting the visual on the common date column from CalendarDates?

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.