Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register 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) )
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 55 | |
| 45 | |
| 38 | |
| 16 | |
| 14 |
| User | Count |
|---|---|
| 87 | |
| 69 | |
| 38 | |
| 29 | |
| 26 |