Forum Discussion

corange's avatar
corange
Post Patron
6 years ago

Filter 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...
Need Help
corange's avatar
corange
Post Patron
6 years ago

Hi  , 

 

Just to clarify things, I want the <= 3 to be removed from all calculations no matter if I select BU A or not. In the summary table, if all BUs are selected then it will still remove <= 3 for BU A and present the results for all and when selecting BU A, then it will also remove <= 3 and present the result. 

 

So whihc measure should I go with? 

 

where I am confused it is the results you are getting for your average. It doesnt match what I would expect. What can we do to clarify the situation and make sure? 

 

Thank you. 

corange's avatar
corange
Post Patron
6 years ago

The <=3 Job for BU A applies no matter if I select the BU A to view averages or if I want to see averages across all BU. When an employee does less than 3 jobs a day in BU A, it is automatically removed from the calculation.