Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi @Anonymous ,
I'm not clear about your formula. Is "average" a entire one? If it is, for the formula [CALCULATE (SUM ( 'Tâches'[Soustraction] )], it will return an aggregation value. You can't add it directly into FILTER function. There should be an Boolean expression like ['Tâches'[Nom du Compartiment]="Bench"&&'Tâches'[Progression]="Terminé"] or [&&CALCULATE (SUM ( 'Tâches'[Soustraction] ) >0].
https://docs.microsoft.com/en-us/dax/filter-function-dax
Can you please share the logic of calculation and your expected output? Then we will understand more clearly about your requirement.
Hello @v-xuding-msft !
I want to calculate the average number on the "soustraction" column for the lines in which :
- Progression = "Terminées"
- Nom du compartiment = "Bench"
With my example, I wanted to get (16 + 9 + 9) /3 = 11.33
Thanks for advance !
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |