Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have a column named 'Status. with the following values.
Status
Yet to commence
In progress & on schedule
Completed
Behind schedule
I would like to get a total count for each status value.
In the PowerBI report, I would like to dispay the total count for each value. An example of the report layout is, on the left hand side of the report display
Status
Total Issues
TotalIssues
Yet to commence
Total_YetToCommence
In progress & on schedule
Total_InProgress
Completed
Total_Completed
Behind schedule
Total_BehindSchedule
I am new to PowerBI. How can I achieve this. I dont even know if this would be is a formula, or measure etc
TIA
Solved! Go to Solution.
@dd88 , Try these measure
Status wise count = Countrows(Table)
Total Count = Status wise count = Countrows(allselected(Table) )
or
Total Count = Status wise count = Countrows(all(Table) )
@dd88 , Try these measure
Status wise count = Countrows(Table)
Total Count = Status wise count = Countrows(allselected(Table) )
or
Total Count = Status wise count = Countrows(all(Table) )
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.