Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear All.
I am required to Show total number of "issues" based on Sprint6 and status is "Done" .
And show total percantage of for each sprint-5 and sprint6 where status is done.
Sno | Issues | Status | Sprint |
1 | 768 | Done | Sprint6 |
2 | 888 | Done | Sprint6 |
3 | 666 | QA in Progress | Sprint6 |
4 | 999 | Deployed in Prod | Sprint6 |
5 | 567 | Done | Sprint5 |
6 | 900 | Done | Sprint5 |
7 | 100 | In-Progress | Sprint5 |
Thanks & Regards,
SAM_
Solved! Go to Solution.
create a measure for count of Issues in Sprint 6:
Issues in Sprint 6 Done =
CALCULATE(
COUNTROWS('Table'),
'Table'[Sprint] = "Sprint6",
'Table'[Status] = "Done"
)
another measure for percentage for sprint 5 and sprint 6:
Percentage Done =
DIVIDE(
CALCULATE(
COUNTROWS('Table'),
'Table'[Status] = "Done",
'Table'[Sprint] = "Sprint6"
),
CALCULATE(
COUNTROWS('Table'),
'Table'[Sprint] = "Sprint6" || 'Table'[Sprint] = "Sprint5"
)
)
it will calculate percentage of issues in Sprint 5 and Sprint 6 that are done. put this in chart to see values.
If this helped, Follow this blog for more insightful information about data analytics
https://analyticpulse.blogspot.com/
https://analyticpulse.blogspot.com/2024/04/commercial-real-estate-portfolio.html
@Fowmy & @AnalyticPulse Thank you both for taking time form your busy schudle and supporting me in getting my solutions.
@SAM_
Create two measures
Issues Count = CALCULATE( SUM(Table04[Issues]), Table04[Status] = "Done" )
Issues Count % =
DIVIDE(
[Issues Count],
CALCULATE(SUM(Table04[Issues]), ALL(Table04[Status] ))
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
create a measure for count of Issues in Sprint 6:
Issues in Sprint 6 Done =
CALCULATE(
COUNTROWS('Table'),
'Table'[Sprint] = "Sprint6",
'Table'[Status] = "Done"
)
another measure for percentage for sprint 5 and sprint 6:
Percentage Done =
DIVIDE(
CALCULATE(
COUNTROWS('Table'),
'Table'[Status] = "Done",
'Table'[Sprint] = "Sprint6"
),
CALCULATE(
COUNTROWS('Table'),
'Table'[Sprint] = "Sprint6" || 'Table'[Sprint] = "Sprint5"
)
)
it will calculate percentage of issues in Sprint 5 and Sprint 6 that are done. put this in chart to see values.
If this helped, Follow this blog for more insightful information about data analytics
https://analyticpulse.blogspot.com/
https://analyticpulse.blogspot.com/2024/04/commercial-real-estate-portfolio.html
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |