Get total count of Column and Percentage in Power BI

[Anonymous]

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_

[Anonymous]

@Fowmy  & @AnalyticPulse  Thank you both for taking time form your busy schudle and supporting me in getting my solutions.

[Fowmy]

@Anonymous 

Create two measures 

Issues Count = CALCULATE( SUM(Table04[Issues]), Table04[Status] = "Done" )

Issues Count % = 
DIVIDE(
    [Issues Count],
    CALCULATE(SUM(Table04[Issues]), ALL(Table04[Status] ))
)

[AnalyticPulse · Accepted 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