Forum Discussion

michaedcarrell's avatar
michaedcarrell
New Member
8 years ago
Solved

Creating Measure - Conditional Average

Hey Everyone,   Need help with this for a class. I am trying to create a conditional average to tell the average enrollment over the total number of years given that a school "Type" is "Independent...
  • dilumd's avatar
    dilumd
    8 years ago

    Try below,

     

    Measure = CALCULATE(AVERAGE(Enrollment2[Enrollment]),FILTER(CollegeInfo,CollegeInfo[Type] = "Independent"))

dilumd's avatar
dilumd
Icon for Impactful Individual rankImpactful Individual
8 years ago

Try below,

 

Measure = CALCULATE(AVERAGE(Enrollment2[Enrollment]),FILTER(CollegeInfo,CollegeInfo[Type] = "Independent"))

michaedcarrell's avatar
michaedcarrell
New Member
8 years ago

Worked like a charm. Thank you!