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 ,
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