Forum Discussion
Post PatronHow to display the Total Count for each value in a Column
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
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) )
2 Replies
- amitchandak
Super User
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) )
dd88amitchandak Thanks amitchandak