How can I filter a PowerPivot table based on a calculated measure?

[res.marcus]

Hi,

I'm trying to build a system that can localize large deviations in survey data. Right now I'm using PowerPivot to calculate all the "weekly answer levels" for the survey questions (as a percentage). Also I have created a four-week moving average which I compare the to the weekly answer levels, and if the deviations are above a centain percentage level I return the number 1, else I return a 0.

Now I want to be able to filter out all questions that do not have any large deviations. Can I somehow use a calculated Boolean-measure to do this? Or are there any other smart ways to accomplish what I´m trying to do?

Best,
Marcus

 

[powerpivotpro]

Can you send me the workbook, or a workbook with sample data illustrating the problem?

 

[res.marcus]

Hi,

I sent you a workbook with some sample data.

Best,
Marcus