PowerBI Jira TIckets Dashboard

0
votes

Hi all i have a question about PowerBI.

I have two columns for jira Tickets the created date and resolution date. As an example a ticket created 1/1/2020 and closed 2/2/2020. I have created a measure for the tickets created

Total = DISTINCTCOUNT('search?jql=project=ZUP-SUP&maxResults=1500'[Column1.key])

and according to the weeknumbercreate(create a new column with extracted information form created) the ticket created i show the following result enter image description here

I did exactly the same for the closed tickets. Now i would like to calculate to show exactly the same diagramm with week numbers and show for every weeknumber how many tickets were in progress. The only way to calculate that is from created day column and closed. Do you have any idea how i could implement that?

Thank you in advance

1
powerbi

1 Answers

0
votes

Try calculate this as:

TicketInProgress =
CALCULATE (
    DISTINCTCOUNT ( 'YourTableName'[Column1.key] ),
    FILTER (
        ALL ( YourTableName[created], YourTableName[closed] ),
        SELECTEDVALUE ( YourTableName[created] ) >= YourTableName[YourWeekSourceColumn]
            && YourTableName[YourWeekSourceColumn] <= SELECTEDVALUE ( YourTableName[closed] )
    )
)