Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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"))
Hello @lardo5150,. You can use "Matrix" Visualization to achieve this. Please find the screenshot attached. I hope it helps!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
85 | |
84 | |
67 | |
49 |
User | Count |
---|---|
131 | |
112 | |
99 | |
69 | |
67 |