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. 

v-yingjl's avatar
v-yingjl
Community Support
6 years ago

Hi corange ,

Based on your description, I want to confirm something based on my sample:

  1. No matter which BU has been selected, all of values <=3 should be ignored to calcualte average
  2. If all BUs are selected, just ignore values <=3 in BU A ,other BU values <=3 should be retained to calcualte average
  3. When select BU A, all of values <=3 should be ignored to calcualte average
  4. If no BU is selected, all of values <=3 should be ignored to calcualte average

If my understanding is still partly wrong, please let me know to better help you.

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.