Forum Discussion
Calculate filter
Hello guys, I have some issues with a meassure, im trying to get the Average score of a customer survey, there are 5 questions, but the most important one are only three. How could I calculate t...
hi, Anonymous
Yes, you could use your formula in calculation.
For your requirement, there are many ways could be done, you just add a filter conditional in formula.
Your formula and GeraldZ's way are all right ways.
Best Regards,
Lin
I would add another column that works as an indicator, something like "Include in Avg" and you can have a Y or N or 1 or 0 then add that as a FILTER criteria in your CALCULATE formula.