Forum Discussion
Anonymous
6 years agoNot applicable
Calculate average by group ignoring certain filter
Hello, my data looks like the following Date Emloyee Group Task Duration 2020-01-01 A 1 aa 2 2020-01-01 ...
amitchandak
Super User
6 years agoAnonymous ,
Refer this can help. You have to use all except and filters
https://community.powerbi.com/t5/Desktop/SUM-of-AVERAGE/td-p/197013