Forum Discussion
corange
Post Patron
Post PatronFilter on Aggregation
Hi POWER BI Team, I need your help on a project and I will try my best to explain the desired outcome. My company is structured into 3 Business Units (BUs) - BU A, BU B, BU C, and we have a...
amitchandak
Super User
Super Usercorange , You have to try something like this
AverageX(filter(summarize(Table, Table[employee], "_sum" ,sum(Table[No of jobs])),[_sum]>3),[_sum])
or
AverageX(filter(summarize(Table, Table[employee], "_sum" ,sum(Table[No of jobs])),[_sum]>3),divide([_sum],count([employee])))