Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
lardo5150
Microsoft Employee
Microsoft Employee

Count Total Specific Values for each person in a Table

I have tried a few things, but I either get zero results, or the formula is giving me errors when it is clearly working for others.

 

I am pulling a SPO List.

 

The list looks like this:

lardo5150_0-1690723719923.png

 

So the list shows how all the request from an engineer and if it was Approved, Denied, or it TimeOut.

 

I am trying to create a table visual, where it will list each engineer, and show me their Total Requests, how many Approved, Denied, and Timeout

lardo5150_1-1690723789571.png

 

Trying a measure like this, but it is giving me an error:

lardo5150_2-1690723823660.png

 

lardo5150_3-1690723901397.png

 

 

I tried this, but got zero results:

Count = CALCULATE(Countrows(Table),Table[Column]="Overdue")

This also got me zero results:

Pass= COUNTROWS(filter(Samples,Samples[AnalysisResult]="Pass"))

1 REPLY 1
AbhinavJoshi
Responsive Resident
Responsive Resident

Hello @lardo5150,. You can use "Matrix" Visualization to achieve this. Please find the screenshot attached. I hope it helps! 

AbhinavJoshi_3-1690760851889.png

 

AbhinavJoshi_2-1690760832830.png

 

AbhinavJoshi_0-1690760800666.png

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors