Forum Discussion

jmscrx's avatar
jmscrx
Helper I
2 years ago
Solved

Average across multiple columns producing wrong number?

Apologies in advance because I feel like I'm missing something obvious here, however I'm simply trying to write a measure that produces the average of the values across multiple columns (ultimately I...
  • Irwan's avatar
    2 years ago

    hello jmscrx 

     

    your DAX looks good but you misplaced your bracket. This DAX means Value6 got divided by 6 then add to Value1 up to Value5.

     

    tried your data with your DAX and the result is as you need.

     

    Hope this will help you.

    Thank you.