Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I need to figure out how to calculate average of the percentage.
I have a matrix table below. I need average of the percentage of all Categories per Label.
Label | Label 1 | Label 2 | Label 3 | Label 4 | Total | |||||
Category | IDs | IDs % | IDs | IDs % | IDs | IDs % | IDs | IDs % | IDs | IDs % |
A | 96 | 20.1% | 134 | 28.1% | 29 | 6.1% | 218 | 45.7% | 477 | 100.0% |
B | 62 | 24.9% | 37 | 14.9% | 4 | 1.6% | 146 | 58.6% | 249 | 100.0% |
C | 200 | 21.5% | 165 | 17.7% | 48 | 5.2% | 519 | 55.7% | 932 | 100.0% |
D | 70 | 29.9% | 26 | 11.1% | 3 | 1.3% | 135 | 57.7% | 234 | 100.0% |
Total | 270 | 17.0% | 348 | 21.9% | 75 | 4.7% | 895 | 56.4% | 1588 | 100.0% |
Needed | 24.1% | 17.9% | 3.5% | 54.4% | 100.0% |
Your total numbers look off. Do you have another filter?
User | Count |
---|---|
49 | |
48 | |
19 | |
16 | |
16 |
User | Count |
---|---|
110 | |
45 | |
42 | |
24 | |
20 |