Forum Discussion

Christann's avatar
Christann
Icon for Advocate IV rankAdvocate IV
7 years ago
Solved

What is wrong with my measure?

Here is my Measure:   Adjusted Water Level = VAR WaterLevel = SUMX(Chickens,DIVIDE(Chickens[Water Level],2,0)) VAR Adjuster = CALCULATE(AVERAGE(Chickens[# of Eggs]),ALL(Chickens[Dates])) Return...
Need Help
  • rafaelmpsantos's avatar
    rafaelmpsantos
    7 years ago

    I think that the problem is in the all(Chickens[Dates]) in calculate filter, take it off

Christann's avatar
Christann
Icon for Advocate IV rankAdvocate IV
7 years ago

The problem is that I do want the average of all the values. Am I confused, and it will do that anyway?

rafaelmpsantos's avatar
rafaelmpsantos
Icon for Responsive Resident rankResponsive Resident
7 years ago

The second VAR will always give you the same value, is that you want? 

  • Christann's avatar
    Christann
    Icon for Advocate IV rankAdvocate IV
    7 years ago

    I think that your first idea actually does work! Thank you so much!