Difference between average and selected value

[Anonymous]

How to subtract the responding value from the average score in 2021(In this small sanmple data,i.e average of bolding numbers) for all Name

sample data:

Name	id	Date	Score
A	1	1/9/2021	6
B	1	1/7/2021	7
C	1	2/8/2021	8
A	2	1/8/2022	9
B	2	1/6/2022	10

expected outcome:

-1

0

1

2

3

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Expected outcome measure: =
VAR _avg2021 =
    AVERAGEX (
        ADDCOLUMNS (
            FILTER ( ALL ( Data ), YEAR ( Data[Date] ) = 2021 ),
            "@score", [Score measure:]
        ),
        [@score]
    )
RETURN
    IF ( HASONEVALUE ( Data[Name] ), [Score measure:] - _avg2021 )