Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. 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) )
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
60 | |
58 | |
56 | |
38 | |
28 |
User | Count |
---|---|
82 | |
62 | |
45 | |
41 | |
40 |