Forum Discussion
PowerBI Jira Connector - Issues Per Assignee over Time
Hi BSands ,
As we haven’t heard back from you, we will go ahead and close this ticket for now.
If you need any further assistance, please don’t hesitate to raise a new ticket, we’re always happy to help.
If the issue still persists, I’d recommend raising a support ticket with Microsoft. The support team can look into the backend and provide more in-depth assistance tailored to your environment.
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket
Our sincere apologies if there was any inconvenience caused.
Regards,
B Manikanteswara Reddy
Hi BSands ,
Since you are close to the solution, you can try the approach that suggested by @Akash_varuna only. The issue is that your current setup only shows tickets assigned on a specific day, but it's not tracking how many tickets are actively assigned to someone like Bob over time.
To show the full history of assignments (like a running total of what Bob has assigned on each day), you no need to create a new historical table, instead, you can create a DAX measure that checks if a ticket was still assigned on each date.
Create a normalized date column in your History_Status table if History New Value Start contains timestamps:
StartDateOnly = DATE(YEAR([History New Value Start]), MONTH([History New Value Start]), DAY([History New Value Start]))
You can do the same for History New Value End column as well.
Then create the DAX as below:
Tickets Assigned to Bob =
VAR SelectedDate = SELECTEDVALUE('Date'[Date])
RETURN
CALCULATE(
COUNTROWS(
FILTER(
'History_Status',
'History_Status'[History Field] = "assignee" &&
'History_Status'[History New Value] = "bob" &&
'History_Status'[StartDateOnly] <= SelectedDate &&
(
ISBLANK('History_Status'[EndDateOnly]) ||
'History_Status'[EndDateOnly] >= SelectedDate
) &&
NOT (
'History_Status'[Key] IN
CALCULATETABLE(
VALUES('History_Status'[Key]),
'History_Status'[History Field] = "status",
'History_Status'[History New Value] = "done",
'History_Status'[StartDateOnly] <= SelectedDate
)
)
)
)
)
|
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos " – I’d truly appreciate it! |
Regards,
B Manikanteswara Reddy
Hello,
Thank you for this, I think it's close but not quite there. It's giving me the number of tickets that were added to their assignment on any given day, but not the running total. See screenshot
There shouldn't be any columns with 0 value, as there are always tickets assigned.
Hi BSands ,
Sorry to hear this hasn't been resolved yet.Could you please try the below DAX measure.
RunningTicketsBob=
VAR SelectedDate = SELECTEDVALUE('Date'[Date])
VAR DoneTickets =
CALCULATETABLE(
VALUES('History_Status'[Key]),
'History_Status'[History Field] = "status",
'History_Status'[History New Value] = "done",
'History_Status'[StartDateOnly] <= SelectedDate
)
RETURN
CALCULATE(
DISTINCTCOUNT('History_Status'[Key]),
FILTER(
'History_Status',
'History_Status'[History Field] = "assignee" &&
'History_Status'[History New Value] = "bob" &&
'History_Status'[StartDateOnly] <= SelectedDate &&
(
ISBLANK('History_Status'[EndDateOnly]) ||
'History_Status'[EndDateOnly] >= SelectedDate
) &&
NOT('History_Status'[Key] IN DoneTickets)
)
)If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
B Manikanteswara Reddy
Hi BSands ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Please don't forget to give a "Kudos " – I’d truly appreciate it!
Regards,
B Manikanteswara Reddy
Hello,
This is giving the same information, a visual of how many tickets were added to the Backlog status on that date, but not with a running total of how many are in that status on that date.
Hi BSands ,
Thank you for the follow-up, and sorry to hear that you're still experiencing the issue
Could you please share the sample pbix along with expected result or a sample output you're aiming for? That would help a lot in providing a more accurate solution.
👉 Please make sure not to include any sensitive or confidential data in the sample
Regards,
B Manikanteswara Reddy