Forum Discussion
Calculating average with values more than x
I have this very simplified data sheet: WorkerName Date ProductsMade John 2019/12/01 40 John 2019/12/01 50 John 2019/12/05 90 John 2019/12/05 70 John 2019/12/07 110 ...
Hi az38 and thanks,
will try that but I must first somehow calculate the sum of the ProductsMade by worker per day and then apply that measure.
-Pasi
az38
Community Champion
Community ChampionProductsMade = CALCULATE(SUM('Table'[Products]);ALLEXCEPT('Table';'Table'[WorkerName];'Table'[Date]))
do not hesitate to give a kudo to useful posts and mark solutions as solution