Forum Discussion
Solved
Average everything else
HI All, I am new to Dax and I can't seem to figure out how to find the average of all values in the category without including the present row of another category. For example, I want to find the...
Thanks so much, Owen. This makes sense. How would I go about defining a measure for the Average? Would I do this with a 'new measure'. Sorry about the simple question.
AlexisOlson
Super User
Super UserIt would just be AVERAGE ( Table1[Column1] ) where you substitute whatever column you're wanting to average instead of my placeholder.