Forum Discussion
Filter on Aggregation
Hi corange ,
Please let me know whether you want to filter all datas which values>=3 before calculate average.
If so, just create measure like this:
Measure =
VAR tab =
SUMMARIZE (
FILTER ( 'Table', 'Table'[value] >= 3 ),
'Table'[BUs],
'Table'[date],
'Table'[state],
'Table'[employee],
'Table'[value]
)
RETURN
AVERAGEX ( tab, [value] )
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.
Hi corange ,
If you want to filter <=3 only choose BU A and calculate average noramlly if no BU has been selected, I think my previous posted measure [average] has achieved it.
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-yingjl ,
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.
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.