Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have 1 year Jira data which has all the Bugs, Builds, Tasks (Issue_type) for each Project. Now i need to calculate the Average number of bugs for project in Quarter 1, Quarter 2, Quarter 3 Quarter 4. , How to calculate the average. I need to do something like, for all the project in Quarter 1 Calculate how many Issue_Type = bug for each project and then divide by number of Projects in that Quarter. This will give me average number of bugs in each quarter.
Solved! Go to Solution.
Hi @Anonymous
1. You need a 1-to-many relationship between the Quarter table (shown right) and the data table (shown left) thru Project name
2. Place QuarterTable[Quarter] in the rows of a matrix visual
3. Place this measure in the visual:
Measure = DIVIDE ( CALCULATE ( COUNTROWS ( Table1 ), Table1[issue type] = "Bug" ), DISTINCTCOUNT( Table1[Project Name] ) )
Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.
Cheers
Hi @Anonymous
1. You need a 1-to-many relationship between the Quarter table (shown right) and the data table (shown left) thru Project name
2. Place QuarterTable[Quarter] in the rows of a matrix visual
3. Place this measure in the visual:
Measure = DIVIDE ( CALCULATE ( COUNTROWS ( Table1 ), Table1[issue type] = "Bug" ), DISTINCTCOUNT( Table1[Project Name] ) )
Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.
Cheers
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |