Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculate Average with filter with a Measure

I thought I had this measure written correcty but it's not calculating.  I need to average the numbers in the Answer column if the Question column is Products. Where did I go wrong?

 

FlexProduct = CALCULATE(AVERAGE('Flex NPS Data'[Answer]),FILTER('Flex NPS Data','Flex NPS Data'[Question] = "Products"))
 

 

Need Help
  • andhiii079845's avatar
    andhiii079845
    3 years ago

    Try:

    FlexProduct = CALCULATE(AVERAGE('Flex NPS Data'[Answer]),FILTER(ALLSELECTED('Flex NPS Data'),'Flex NPS Data'[Question] = "Products"))

     

    Or show the wrong result (with a example of the involved data), what do you expected, and where do you want to use the measure.

1 Reply

  • andhiii079845's avatar
    andhiii079845
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Try:

    FlexProduct = CALCULATE(AVERAGE('Flex NPS Data'[Answer]),FILTER(ALLSELECTED('Flex NPS Data'),'Flex NPS Data'[Question] = "Products"))

     

    Or show the wrong result (with a example of the involved data), what do you expected, and where do you want to use the measure.