Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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) )