cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bryanc78
Helper IV
Helper IV

Measure to count number of items in a column

I have a dataset like this

 

Employee Name      Attendance Issue

Bob                          Absent

Bob                          Absent

Bob                          Absent

Bob                          Late

Bob                          Late

 

I want to be able count the number of employee issues and put them in a table.  So the table woud look like this

 

Name       Absent       Late

Bob           3                 2

 

I'm thinking the best way is to create a measure for each attendance issue I have.  Then put all those measures into a table.

 

It has to be a table and not a matrix as I'm adding other columns to it like Employee Supervisor.  End goal is to then create a calculated column where I can apply weighted values to the different columns to then come up with a "score".  So someone with more absences than someone else would have a lower score

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@bryanc78 

You can create two-measures as follows and use on a table visual:

Absent = CALCULATE( COUNTROWS(T13), T13[  Attendance Issue] = "Absent")
Late = CALCULATE( COUNTROWS(T13), T13[  Attendance Issue] = "Late")

Fowmy_0-1610655785585.png

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂


Website YouTube  LinkedIn

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

1 REPLY 1
Fowmy
Super User
Super User

@bryanc78 

You can create two-measures as follows and use on a table visual:

Absent = CALCULATE( COUNTROWS(T13), T13[  Attendance Issue] = "Absent")
Late = CALCULATE( COUNTROWS(T13), T13[  Attendance Issue] = "Late")

Fowmy_0-1610655785585.png

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂


Website YouTube  LinkedIn

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.