How would I create a calculated group for each day average?

[OCBB_SFAFPandA]

Hello,

I am trying to make a calculated group that can calculate the AVG (Sales $, Transactions count, etc) for each day (Sunday, Monday, ETC.)

I created the Calculated group in Tabular Editor and this is my formula, and there is one for each day. 

VAR WEEKDAYtable =
    FILTER (
        'date',
        date[TheDayName] = "Sunday"
    )
RETURN
    AVERAGEX ( WEEKDAYtable, SELECTEDMEASURE )

 I am running into this error. Would I need to use the calulate function somehow?

[amitchandak]

@OCBB_SFAFPandA , it should be selectedmeasure function

SELECTEDMEASURE()

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0