Forum Discussion

pintobean87's avatar
pintobean87
Frequent Visitor
3 years ago

Error while trying to sum and get the average from two calculated columns

Hi all.   So I have the following 3 columns in my table: Name, QTR 1, QTR 2. QTR 1 and 2 are calculated columns that I made to get the difference from other columns. It's important to note t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi pintobean87 

Try the following measure

Measure = var a=CALCULATE(AVERAGE('Table'[QTR1]),ALLEXCEPT('Table','Table'[Name]))
var b=CALCULATE(AVERAGE('Table'[QTR2]),ALLEXCEPT('Table','Table'[Name]))
return a+b

Output

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.