Forum Discussion

lardo5150's avatar
lardo5150
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

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:

 

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's avatar
    AbhinavJoshi
    Icon for Responsive Resident rankResponsive Resident

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