Forum Discussion
lardo5150
Microsoft Employee
3 years agoCount 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:
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
Trying a measure like this, but it is giving me an error:
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
- AbhinavJoshi
Responsive Resident
Hello lardo5150,. You can use "Matrix" Visualization to achieve this. Please find the screenshot attached. I hope it helps!