Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I am calculate a average value in a matrix table. Every worker has record, 1 or 0(Column 0 or 1). If there is any record not 0, it count 1(Column Max of 0 or 1). What I want is average as showing in the picture. I spent a lot of time to write a measure, but it is always wrong. Really need help!!
Thank you in advance!
Bran
Job Desc | Name | 0 or 1 |
Foreman | Allan Doole | 0 |
Foreman | Allan Doole | 0 |
Foreman | Allan Doole | 0 |
Foreman | Allan Doole | 0 |
Foreman | Allan Doole | 0 |
Foreman | Ben Ju | 1 |
Foreman | Ben Ju | 0 |
Foreman | Ben Ju | 1 |
Foreman | Ben Ju | 1 |
Project Manager | Andy Young | 1 |
Project Manager | Andy Young | 0 |
Project Manager | Andy Young | 0 |
Project Manager | Andy Young | 0 |
Project Manager | Craig Thorsen | 0 |
Project Manager | Craig Thorsen | 0 |
Project Manager | Craig Thorsen | 0 |
Project Manager | Craig Thorsen | 0 |
Project Manager | Craig Thorsen | 0 |
Safety Coordinator | Abednego Shu | 1 |
Safety Coordinator | Abednego Shu | 0 |
Safety Coordinator | Abednego Shu | 0 |
Safety Coordinator | Abednego Shu | 0 |
Safety Coordinator | Abednego Shu | 0 |
Safety Coordinator | Abednego Shu | 0 |
Safety Coordinator | Andrew Hadley | 0 |
Safety Coordinator | Andrew Hadley | 1 |
Safety Coordinator | Andrew Hadley | 1 |
Safety Coordinator | Andrew Hadley | 0 |
Safety Coordinator | Andrew Hadley | 0 |
Solved! Go to Solution.
Hi @Anonymous
Please try
Average =
AVERAGEX (
VALUES ( 'Test'[Name] ),
CALCULATE ( MAX ( 'Test'[0 or 1] ) )
)
Hi @Anonymous
Please try
Average =
AVERAGEX (
VALUES ( 'Test'[Name] ),
CALCULATE ( MAX ( 'Test'[0 or 1] ) )
)
User | Count |
---|---|
51 | |
27 | |
19 | |
18 | |
14 |
User | Count |
---|---|
91 | |
86 | |
39 | |
23 | |
22 |