Problems with AVG line on chart

Hi,

Thanks for the solution dk_dk  offered,and i want to offer some more information for user to refer to.

hello baneworth ,based on your description, you can try the following code.

AVG_Rating =
VAR a =
    SUMX ( ALLSELECTED ( Fact_QCBS[Serial Numner] ), [Total Rating] )
VAR b =
    CALCULATE (
        DISTINCTCOUNT ( Fact_QCBS[Serial Numner] ),
        ALLSELECTED ( Fact_QCBS )
    )
RETURN
    DIVIDE ( a, b ) + 0

If the solution cannot meet your requirement, can you provide some sample data so that can provide more suggestion for you.

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.