Control Chart in Power BI

Hi Anonymous ,

According to the error message, the averagex function returns the average value of the expression calculated for each row in the table, AVERAGEX (<table name>, <expression> ). "Table name" is a table that uses expression to evaluate each row: "Expression" is an expression that is evaluated for each row of the table. Refer to the following formula.

Average Oil Variance = 
CALCULATE (
    AVERAGEX ( 'DATA', DATA[Oil Variance] ),
    ALLSELECTED ( DATA[Date] )
)

If the problem is still not resolved, can you provide an effective data model (delete sensitive information), I will answer you as soon as possible.

Best Regards,
Henry

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