Fields within Set Analysis

[Anonymous]

I am calculation the average score but also have a check that the Survey_date and SendDate are the same. I know the first part of the set analysis but it is the Survey_date part which is causing the error. Both Survey_date and SendDate are both fields.

Avg({<FFMessage={'Score - Sales investigation'}, Survey_date={"=$(=SendDate)"}>}[Given Score])

[ali_hijazi]

avg({<FFMessage={'Score - Sales investigation'}>}if(Survey_date=SendDate,GivenScore))

or

avg({<FFMessage={'Score - Sales investigation'},Key_Column={"=Survey_date=SendDate"}>}GivenScore)

[shraddha_g]

not so sure but

Avg({<FFMessage={'Score - Sales investigation'}, Survey_date = p(SendDate)>}[Given Score])